In this video, we’ll look at how to simplify some formulas we created in a previous video, by replacing IF statements with the MIN function and a bit of boolean logic.
Make sure you watch the first video if you haven’t already.
In the example, we have formulas that calculate a company match for an employer-sponsored retirement plan in two tiers.
Both tiers use one or more IF statements, and the second formula is a bit complicated.
Let’s look at how to simplify the formulas a bit.