Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Convert nested IFs into readable AND / OR

1385 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