# Thread: Discount Percentage  Unexpected Res

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

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