rounding issues

[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

 

[JE McGimpsey]

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.