USE THE IF FUNCTION TO CALCULATE WITH DIFFERENT TAX RATES USING MICROSOFT EXCEL

If two or more different tax rates have to be handled, you can use the IF function to calculate each one individually. Simply combine several IF functions, depending on the calculation.

To calculate the price after tax:

1. In column A, enter some prices.
2. In column B, enter different tax percentages (0, 8, or 10 for this example).
3. Select cells C2:C10 and type the following formula: =IF(B2=8,A2/100*8,IF(B2=10,A2/100*10,A2/100*0)).
4. Press <-Ctrl+Enter->.
5. Select cells D2:D10 and type the formula =A2+C2.
6. Press <-Ctrl+Enter->.

USE THE IF FUNCTION TO CALCULATE WITH DIFFERENT TAX RATES USING MICROSOFT EXCEL

Microsoft Excel Tutorials, MS Excel Tutorials, Logical Functions in Excel, IF Function in Excel, Use the IF function to calculate with different tax rates using MS Excel, Video Tutorials of Microsoft Excel, Advanced Functions in Excel, Formulas in Excel, Using Macros & VBA Codes in Excel