Convert nested IFs into readable AND / OR

1636 0
Showing results for 
Search instead for 
Did you mean: 

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.

0 Replies 0