| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
help please with simple formula
F4 i have 0
H4 i have 6 J4 i have 1.12 The answer in N4 is 6 (good enough but would like to round to nearest No which should be 7) Formula used is =H4-F4*J4 F7 i have 0 H7 i have 6 J7 i have 2.24 The answer in N7 is still 6 ( it should be 12, double the one above) Formula used is =H7-F7*J7 just can`t work this out. help please thanks |
|
#2
|
|||
|
|||
|
Scudo wrote:
F4 i have 0 H4 i have 6 J4 i have 1.12 The answer in N4 is 6 (good enough but would like to round to nearest No which should be 7) Formula used is =H4-F4*J4 F7 i have 0 H7 i have 6 J7 i have 2.24 The answer in N7 is still 6 ( it should be 12, double the one above) Formula used is =H7-F7*J7 just can`t work this out. help please thanks the multiplcation takes place first thus for the first formula you have 6- 0, zero times anything is zero. This applies to the second formula also. Try (H7-F7)*J7 If you wnat it rounded try the Round function gls858 |
|
#3
|
|||
|
|||
|
You need some parens, Scudo:
=(H4-F4)*J4 What it's doing now is taking H4-(F4*J4) ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Scudo" wrote in message ... F4 i have 0 H4 i have 6 J4 i have 1.12 The answer in N4 is 6 (good enough but would like to round to nearest No which should be 7) Formula used is =H4-F4*J4 F7 i have 0 H7 i have 6 J7 i have 2.24 The answer in N7 is still 6 ( it should be 12, double the one above) Formula used is =H7-F7*J7 just can`t work this out. help please thanks |
|
#4
|
|||
|
|||
|
Sorry, Scudo. Rounding:
http://www.officearticles.com/excel/...soft_excel.htm ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Anne Troy" wrote in message news:406ca$42cd8525$97c5108d$11996@allthenewsgroup s.com... You need some parens, Scudo: =(H4-F4)*J4 What it's doing now is taking H4-(F4*J4) ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Scudo" wrote in message ... F4 i have 0 H4 i have 6 J4 i have 1.12 The answer in N4 is 6 (good enough but would like to round to nearest No which should be 7) Formula used is =H4-F4*J4 F7 i have 0 H7 i have 6 J7 i have 2.24 The answer in N7 is still 6 ( it should be 12, double the one above) Formula used is =H7-F7*J7 just can`t work this out. help please thanks |
|
#5
|
|||
|
|||
|
Thanks again to all for help, my problem (s) are now sorted.
regards Scudo "Anne Troy" wrote in message news:e8e0e$42cd899d$97c5108d$26641@allthenewsgroup s.com... Sorry, Scudo. Rounding: http://www.officearticles.com/excel/..._microsoft_exc el.htm ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Anne Troy" wrote in message news:406ca$42cd8525$97c5108d$11996@allthenewsgroup s.com... You need some parens, Scudo: =(H4-F4)*J4 What it's doing now is taking H4-(F4*J4) ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Scudo" wrote in message ... F4 i have 0 H4 i have 6 J4 i have 1.12 The answer in N4 is 6 (good enough but would like to round to nearest No which should be 7) Formula used is =H4-F4*J4 F7 i have 0 H7 i have 6 J7 i have 2.24 The answer in N7 is still 6 ( it should be 12, double the one above) Formula used is =H7-F7*J7 just can`t work this out. help please thanks |
|
#6
|
|||
|
|||
|
Scudo wrote:
Thanks again to all for help, my problem (s) are now sorted. regards Scudo "Anne Troy" wrote in message news:e8e0e$42cd899d$97c5108d$26641@allthenewsgroup s.com... Sorry, Scudo. Rounding: http://www.officearticles.com/excel/..._microsoft_exc el.htm ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Anne Troy" wrote in message news:406ca$42cd8525$97c5108d$11996@allthenewsgro ups.com... You need some parens, Scudo: =(H4-F4)*J4 What it's doing now is taking H4-(F4*J4) ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Scudo" wrote in message .uk... F4 i have 0 H4 i have 6 J4 i have 1.12 The answer in N4 is 6 (good enough but would like to round to nearest No which should be 7) Formula used is =H4-F4*J4 F7 i have 0 H7 i have 6 J7 i have 2.24 The answer in N7 is still 6 ( it should be 12, double the one above) Formula used is =H7-F7*J7 just can`t work this out. help please thanks Glad you got it sorted. Thanks for posting back. gls858 |
|
#7
|
|||
|
|||
|
Dear Scudo
I think it's now been answered, but remember in general that excel follows mathematical conventions. eg BODMAS (easy to remember) -- formualae are resolved in the strict order: * Brackets Of Divide Multiply Add Subtract*. So if you want to add or subtract *before* multiplying/dividing then you must use brackets round the items to first be added/subtracted. eg 4 X 5-1 = 19 -- multiplies first then subtracts but 4 X (5-1) = 16 -- does what's in the brackets first then multiplies gls858 wrote: F7 i have 0 H7 i have 6 J7 i have 2.24 The answer in N7 is still 6 ( it should be 12, double the one above) Formula used is =H7-F7*J7 just can`t work this out. help please thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Simple formula help | Excel Worksheet Functions | |||
| help with simple formula | Excel Worksheet Functions | |||
| Excel Miscalculates simple formula..Help!! | Excel Worksheet Functions | |||
| Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
| Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Linear Mode
