Closed Thread
Results 1 to 2 of 2

rounding issues

  1. #1
    daylapira@gmail.com
    Guest

    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. #2
    JE McGimpsey
    Guest

    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
    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.



    In article <1141072153.512131.321900@v46g2000cwv.googlegroups.com>,
    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


Closed Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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