Roundup Decimal

K

Kitty

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
 
P

Peo Sjoblom

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
tools>options>calculation and check precision as displayed, however that
will affect all values
 
K

Kitty

Hi Peo Sjoblom

That did the trick - thanks a lot - I had trouble with the syntax
to merge sum & round ;-) But as you said no need to use
sum!!

Hugs
 
Top