Tax rate calculation with two rates

To calculate a sales tax with two rates (brackets), you can use the IF function. In the example shown, the formula in C5, copied down, is: =IF(B5

April 14, 2025 · 1 min · 63 words · Alexis Hughes

Table of Contents

This problem illustrates how to use the IF function to return different calculations.

At the core, this formula uses a singleIF function.

Notice B5 is still arelative referencebecause we want the reference to change as the formula is copied.

Tax rate calculation with two rates with absolute references

More than one condition can be tested by nesting IF functions.

The IF…

The IF function

Tax rate calculation with two rates with absolute references

Excel formula: VLOOKUP tax rate calculation

Excel formula: Tax rate calculation with fixed base

Excel formula: Income tax bracket calculation

Excel IF function