Nested IF statement with Checkbox

tarmstrong

I have 3 fields.  2 fields are checkboxes and 1 is text.  

Active (checkbox)

Not Active (checkbox)

Complete (Yes/No)

I want to write a nested IF statement that if either are checked it provides a Yes / No response.

IF(ACTIVE = TRUE, "Yes", IF(OR(NOT ACTIVE = TRUE, "Yes", "No")))

I get the field to work how I want for Active but when the box is checked for Not Active I get an #Incorrect and if none are checked I get #incorrect.

Any help appreciated.  

 

Nic Larsen

Maybe this will help with formula formatting... i'm not totally sure I understand your 2nd argument. 

1 = checked / 0 = unchecked

=IF([Not Active]@row = 1, "No", IF(Active@row = 1, "Yes", "No"))

 

Paul Newcome

Try this...

 

=IF(OR(Active@row = 1, [Not Active]@row = 1), "Yes", "No")