|
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 |
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 |
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 |
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 |
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 |
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 |
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 |
| All times are GMT +1. The time now is 08:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com