Nested IF and OR (and possibly AND)

Hello,

I have two checkbox columns: one for Arabic and one for English.  These columns will either be checked, unchecked or say "n/a".

What I want is to have another checkbox column where it is checked if Arabic and English are both either checked or "n/a": for example:

IF Arabic = 1 OR “n/a” AND IF English = 1 OR “n/a”, then 1, if not then 0

I hope that makes sense, I'm just not sure how to nest these.  Please let me know if you need any clarification.

Cheers,

Nicky

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!