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:
Bingo!
Now I feel empowered to get even fancier with my formulas (if I need to) because I have these additional functions.