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%)

IFERROR With VLOOKUP And LEN AND LENB FUNCTION

Combining the IFERROR Function Formula with Logical VLOOKUP Functions Formula IFERROR Function With VLOOKUP Function Formula Description : - Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula. Use the IFERROR Function With VLOOKUP function to trap and handle errors in a formula Below Following Values if Error : - #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL! For Example A B C D Description Value Description Value Lookup Product #N/A Product 0 Produ...

Excel Some Useful Shortcuts Excel Some Useful Shortcuts Shortcut key Action Menu equivalent comments Alt or F10 Menu Go to Menu bar Alt+’ Format Style dialog box Format the Style Alt+= AutoSum Sum Formaula Showing in Cell Alt+Down arrow Display AutoComplete list Displaying Auto Complete Data List Alt+F1 Insert Chart Insert the Chart Alt+F11 Visual Basic Editor Tools, Macro, Visual Basic Editor Alt+F2 Save As Save File to Save As Alt+F4 Exit File Exit Alt+F8 Macro dialog box Macro dialog box Tools Alt+Shift+F1 New worksheet Insert New Worksheet Alt+Shift+F2 Save Save the File Ctrl + Shift + L Filter Filter the Row Ctrl W Close Close the Open File Ctrl+- Delete Delete the Rows, Columns and Cells Right or Down Depends on selection Ctrl+! Format cells dialog box Font Tab Open in F...

Basic Excel Simple formulas

Search This Blog