Nested IF and OR (and possibly AND)
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.