10. Use the IF function to calculate with different tax rates
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->.
Watch the Video Tutorial - https://www.youtube.com/watch?v=AA4b_wK13BQ
Hope You Like This Tutorials - Give Comments
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->.
Watch the Video Tutorial - https://www.youtube.com/watch?v=AA4b_wK13BQ
Hope You Like This Tutorials - Give Comments
No comments:
Post a Comment