Nested IF and OR (and possibly AND)

06/28/18 Edited 12/09/19


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.



Popular Tags:


Sign In or Register to comment.