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