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

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


--

Regards,

Peo Sjoblom

"Kitty" <forget@it.com> wrote in message
news:tsnnr199ql0c68hv6mndaki1eq5ig85q5g@4ax.com...
> 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
>

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 <forget@it.com> 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