ExcelBanter - How do I use a formula in excel to get a percentage discount

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I use a formula in excel to get a percentage discount (https://www.excelbanter.com/excel-discussion-misc-queries/110908-how-do-i-use-formula-excel-get-percentage-discount.html)

birch

How do I use a formula in excel to get a percentage discount

How do I Use a percent for a discount in a total

Teethless mama

How do I use a formula in excel to get a percentage discount

Let says the total in A1 =100, and you want 10% discount of the total.

Formula in B1 =A1*(1-0.1) The result will be 90

"birch" wrote:

How do I Use a percent for a discount in a total

All times are GMT +1. The time now is 08:58 AM.