Nested IF statement with Checkbox

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.

Find more posts tagged with

Formulas

Support

Comments

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")

Sign in to join the conversation!

Quick Links

Trending discussions

Lookup Value Issues
I am trying to populate a column from Sheet A into Sheet B and Sheet C. My Lookup column for Sheet A is formatted as such so there is a ' in front to account for ones that have a leading 0 and some do not. Each ID should be 6 digits long. I made a helper column looking at this Dealer ID column to try and get rid of that…
Separating Data into Multiple Rows
am I able to separate this into multiple rows? in a new sheet? Desired Result -
Index Distinct Support
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.