Thread: Roundup Decimal
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kitty
 
Posts: n/a
Default 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