Roundup Decimal
If your value is 12.11 then it should but your value is not 12.11. Don't
confuse formatting (which is display) with the real values. I can format
1000 to look like 10 but that doesn't mean it is 10. You have some options,
either use the round formula
=ROUND(O22/(I22-J22),2) (no need for sum when you have one cell only)
which will round to nearest 2 decimal or you can go to
toolsoptionscalculation and check precision as displayed, however that
will affect all values
--
Regards,
Peo Sjoblom
"Kitty" wrote in message
...
Hi
I'll see if I can explain my problem
I have the following formula in a cell =SUM(O22)/(I22-J22) which
equals the amount of 12.11 (It's actually 12.11368.I only use 2
decimals)
Now I want to multiply the above cell with the 12.11 with another cell
containing 494.00 and the result ought to be 5 982,34 but instead I
get 5 983.00!
All cells involved are formated as currency with 2 decimals
Any suggestions - Tia
Mia
|