# rounding issues

1. ## rounding issues

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  Register To Reply

2. ## Re: rounding issues

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

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.

daylapira@gmail.com wrote:

> 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  Register To Reply