Simplified formula example – 401k Match

Tip: Simplified formula example - 401k Match

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.

Duration 
3:43
Author 

Leave a Reply

Your email address will not be published. Required fields are marked *