rounding issues

  • Thread starter Thread starter daylapira
  • Start date Start date
D

daylapira

I have a simple formula to multiple a cell with another and subtract
from another:=IF(K14<0,K14,IF(K17<K16,K14-K17*K15,K14-(K17*K15))) . I
also have the cell set for currency and two decimals over. The
calculations are automatically rounded up to the nearest $$. how can I
keep that from happening?

cheers

Day
 
First, unless you have the "Precision as displayed" checkbox checked in
Tools/Options/Calculations, the value displayed has only a tenuous
relationship to the value stored.

So you should just be able to specify two decimals in the number format
of your target cell (Format/Cells/Number/Currency).

OTOH, if you truly want to round to two decimal places, try:

=ROUND(IF(K14<0,K14, K14-K17*K15),2)

(note that both the true and false branches of your second IF() are
equivalent). Format the cell with 2 decimal places.
 
Back
Top