lesser-equity

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


Register


Reply
 
Thread Tools
  #1  
Old 29th May 2009, 13:12
New Member Group
 
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
 
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

Register
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.