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