Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    May 2002
    Posts
    36
    Thanks
    9
    Thanked 0 Times in 0 Posts
    I have a question concerning the following formula:

    A1 is the price of the item. Example $19.95

    A2 is the discount percentage. Example 10%

    In A3 is the formula A1*A2. Using my examples, I am getting the following results $19.95 * 10% = $2.00;

    I am expecting the results to be $1.99.

    I have cells A1 and A3 formatted as Number|Accounting and the Decimal Places set to 2.

    A2 format is Number|Percentage and the Decimal Places set to 0.

    I don’t understand why the formula is rounding up to $2.00 vs the $1.99 that I’m expecting

    Any help would be greatly appreciated.

  2. #2
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,191
    Thanks
    48
    Thanked 985 Times in 915 Posts
    I get the same result once the formatting is applied (Excel 2000). Clearing the format on A3 returns 1.995, which when rounded to 2 decimal places is 2.00.
    If you want to round down you need to use a round formula.

    cheers, Paul.

  3. #3
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    Hello sb - The formatting display for A3 is set to automatically be displayed as round up. The actual number in A3 is $1.995. You can see this by setting the cell to 3 decimals.

    If you want to round down, see the formula in Cell B3 in example attached.

    Tim
    Attached Files Attached Files

  4. #4
    Lounger
    Join Date
    May 2002
    Posts
    36
    Thanks
    9
    Thanked 0 Times in 0 Posts
    PT / Tim,

    Thank you very much for your help!!

Posting Permissions

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