0

enter image description here

Is there a formula I use that states, if either check box is checked in row 1, B2, C2, OR D2 (so any of the 3) - it appears in E2 as Present. If none are checked, then absent. The formula I've been using is =IF(B2=FALSE, "ABSENT","PRESENT") but I can't get it to apply to any of the 3 boxes.

0

Please use the following formula in cell E2

=ArrayFormula(IF(B2:B7="","", 
              IF((B2:B7=TRUE)+(C2:C7=TRUE)+(D2:D7=TRUE), 
                      "PRESENT", "ABSENT")))

The formula will auto expand to all cells below it.

enter image description here

| improve this answer | |
0

enter image description here

In column E

=if(B9=true,"Present",if(C9=true,"Present",if(D9=true,"Present","Absent")))

Copied down through the range in column E as required.

Why this works: Nested =IF(TRUE,FALSE) is examined in turn. So if the first condition is TRUE it performs the first TRUE condition, if FALSE it looks to the next nested IF() which is again examined on the same basis through the formula. If no condition is TRUE then the FALSE condition will ultimately apply.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.