Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2003
    Posts
    130

    Question Unanswered: Money Rounding Problem

    I have a sheet with columns formatted as money and sometimes due to calculations, the final value is often off by a penny depending on the actual value of the cell and the displayed value of the cell.

    Actual values:

    12.4999
    14.599
    9.995
    4.5899
    22.4949
    19.1889

    Total
    ----------
    41.6838


    Displayed values (what they SHOULD look like):

    $12.50
    $14.60
    $10.00
    $4.59
    $22.50
    $19.19

    Total
    ----------
    $41.69

    Is there a way to display with the right rounding other than rounding every individual cell with =Round(Cell, 2) ?

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Howdy. Try the ROUNDUP function.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Nov 2005
    Posts
    20
    Programming/Web Design
    http://eofficeprofessionals.com/forums

    Offer solutions-not criticism.

Posting Permissions

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