Convert nested IFs into readable AND / OR


This week I nested an IF function three layers deep. It was hard to read and hard to write. There must be a better way, I thought.

I read some articles that said to avoid nested IFs using AND / OR.

Then I watched this video on how to use it:


Now I feel empowered to get even fancier with my formulas (if I need to) because I have these additional functions.