in a worksheet with the following named ranges: rate = F4, fixed = F5, limit = F6. The rules of this problem are as follows: If TRUE, the formula simply multiplies the amount in B5 by tax rate: If FALSE, the formula applies the tax rate to the amount over 1000, then adds the fixed amount:

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.