Share via

Creating a rule based on multiple columns

Anonymous
2024-02-01T14:28:02+00:00

Hi All,

can you advise how I would get i2 to show as response based on if D2 or E2 is 1 and C2 is1 then answer is yes.

Apologies I'm a total newbie!

A B C D E F G H I
1 Number OPAthoracic Surgery 2WW OPA Resp OPA Other OPA Notes Total interactions Resp & Surgery
2 000000000 1 1 1 1 4 yes
3 000000000 0 0 1 1 2 no
4 000000000 1 1 1 0 3 yes
5 000000000 1 0 1 0 2 no
Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Rich~M 20,370 Reputation points Volunteer Moderator
    2024-02-01T14:54:21+00:00

    Hi Tracy. I am an Excel user like you.

    Here is a formula that will do what you want. Riny also sent a formula that will work when any number is in the evaluated cells. This formula specifically looks for the number 1 in those cells.

    =IF(AND(C2=1,OR(D2=1,E2=1)),"yes","no")

    Image

    Was this answer helpful?

    0 comments
  2. Anonymous
    2024-02-01T14:53:45+00:00

    Yours looks much nicer than mine!! =IF(F3+G3>=1,+E3)

    Thank you, is exactly what I was looking for

    Was this answer helpful?

    0 comments
  3. riny 20,870 Reputation points Volunteer Moderator
    2024-02-01T14:43:55+00:00

    =IF(AND(OR(D2,E2),C2),"yes","no")

    Was this answer helpful?

    0 comments