Friday, 17 February 2017

Discount Formula in Excel

Discount Formula in Excel


To Discount Formula an original price minus 5 is the same as Calculate to 95 of that value so if you have the Product Price (4585) in A2 use the Discount Formula









Here the Below Example for Discount Formulas : - 

5% Discount formula is =A2*0.95

10% Discount formula is =A2*0.90

15% Discount formula is =A2*0.85

20% Discount formula is =A2*0.80

25% Discount formula is =A2*0.75

30% Discount formula is =A2*0.70

40% Discount formula is =A2*0.60

50% Discount formula is =A2*0.50



Another Way to Calculate Discount Formula in Excel

How to Find Discounted Amount in Excel

Column A is Product Price, Column B is Discount Percentage, Column C is Discounted Amount and Column D is After Discount Amount 
 


Discounted Amount Formula is  =A2*5% 





After Discount Amount Formula is =A2-C2



Another Easiest Way to Calculate Discount Formula 

Column A is Product Price, Column B is Discount Percentage % and C is After Discount Minus Price

 


After Minus Discount Formula is =A2-(B2*A2%) 

No comments:

Post a Comment