# 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

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

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1