lesser-equity

Magazine
Go Back   Computer Juice > Computer Software > Office Suites & Applications

Register


Default 8 based calculation in Office Excell

I have problem with devide by 8, how to make answer in excell (A1)35, (B1)8, (C1) "Answer 1", (D1) "Answer 2". I want the answer is: "Answer 1" = 4 and "Answer 2" = 3, Because 35-(8*4)=3. :4-dontkno Thank You:wave:...


Reply
 
Thread Tools
  #1  
Old 29th May 2009, 13:12
New Member Group
 
Posts: 2
Default 8 based calculation in Office Excell

I have problem with devide by 8, how to make answer in excell
(A1)35, (B1)8, (C1) "Answer 1", (D1) "Answer 2". I want the answer is: "Answer 1" = 4 and "Answer 2" = 3, Because 35-(8*4)=3. :4-dontkno
Thank You:wave:
  #2  
Old 29th May 2009, 15:20
Donor Group
 
Skill Level: Intermediate
Posts: 2,010
Default 8 based calculation in Office Excell

I don't understand what you mean, sorry.

Do you mean:


35-(8*4) is 3 yes, is that all you're trying to work out?

I don't see where 4 came into it, or what you're trying to achieve..

EDIT:
In D1, if I'm following you right you need to enter:
Code:
=SUM(A1-(B1*4))
But I don't understand what the 4 is? Where does C1 get the answer 4 from?

(If the answer in C1 IS 4, then you can change the formula in D1 to
Code:
=SUM(A1-(B1*C1))
)


Maybe a little more info and I can help you out
__________________
"Why did they [PS3 Slim] stick with the UFO landing on a rectangle look" --- Nilay Patel; Engadget Ep. 160
__________________

My System: FordyPC

Processor(s):
Quad Q6600 Kentsfield 2.66@3.45GHz
Motherboard:
Asus P5Q/L PRO (Intel P43, ICH10)
RAM Memory:
PNY XLR8 4GB @ 1066MHz
Graphics Card(s):
PNY nVidia GeForce 9400 GT 512MB
Sound Card:
Hard Drive(s):
Seagate HDBarracuda 1x 1TB 1x 250GB
Optical Drive(s):
LG (HD)GGCH20L / LG GH22NP20AUAA50B
Case / PSU:
Antec Sonata III & Earthwatts 500W
Cooling:
Stock
Network / Internet:
Gigabit LAN, FireWire & WG111v2
Monitor(s):
2 x Acer P193WAd
Operating System(s):
XP PRO x86/XP PRO x64/Win7 RC1 x64
Reply

Donate

Register

Bookmarks

Similar Threads
Thread Thread Starter Forum Replies Last Post
Microsoft Excell sumPRODUCT Problem texannatl Office Suites & Applications 0 21st May 2009 23:35
Website Template CMS Based megabyte Web Design, Hosting & SEO 6 7th May 2009 07:14
Is open office compatible with microsoft office pinkypossum001 Office Suites & Applications 2 21st Nov 2008 08:13
Scsi based controllers thekuntash General Hardware Chat 1 8th Nov 2007 11:31
Open office and mirco soft office ken979 Office Suites & Applications 2 12th Aug 2007 04:22
Thread Tools




Arabic Bulgarian Chinese (Simplified) Chinese (Traditional) Croatian Czech Danish Dutch English Finnish French German Greek Hebrew Hungarian Italian Japanese Korean Latvian Lithuanian Norwegian Polish Portuguese Romanian Russian Serbian Slovak Spanish Swedish Thai Turkish Ukrainian

Copyright ©2006 - 2009 Computer Juice.

Powered by vBulletin® Copyright ©2000 - 2009 Jelsoft Enterprises Ltd. SEO by vBSEO ©2009, Crawlability, Inc.