USE THE IF FUNCTION TO CALCULATE THE COMMISSIONS FOR INDIVIDUAL SALES USING MICROSOFT EXCEL

A company has a policy for individual commissions depending on sales, as shown below:

Sale < $100                                                3%
Sale => $100 and < $500                           5%
Sale >= $500                                              8%

To calculate the commissions:

1. Enter different possible sales amounts in column A.
2. Select cells B2:B12 and type the following formula: =A2*IF(A2>=500,0.08,IF(A2>=100,0.05,0.03)).
3. Press <-Ctrl+Enter->.

USE THE IF FUNCTION TO CALCULATE THE COMMISSIONS FOR INDIVIDUAL SALES USING MICROSOFT EXCEL

Microsoft Excel Tutorials, MS Excel Tutorials, Logical Functions in Excel, IF Function in Excel, Use the IF function to calculate the commissions for individual sales using MS Excel, Video Tutorials of Microsoft Excel, Advanced Functions in Excel, Formulas in Excel, Using Macros & VBA Codes in Excel