Roundup Decimal
 

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

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

Roundup Decimal
 

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


On Wed, 04 Jan 2006 14:47:06 GMT, Kitty wrote:

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