Using AND, OR and AND Statements with Multiple Criteria

Question

Level 1

4 points

Using AND, OR and AND Statements with Multiple Criteria

First attempt to use a spreadsheets with multiple criteria...

I could use some help with my formula. I tried using Numbers Help and the community as a resource, both are very beneficial, but I can seem to get the desired results. Hopefully, someone can point me in the right direction. I attempted several variations of my formula, but can't seem to get the desired results.

I need the formal to check A and C. IF one or both are are True (checked), then check E, IF Blank, return in F “Entry required in column E". If A and/or C, are True, and E is NOT blank, the message should not appear in Formula column.

Thank you

MacBook Air (M3, 2024)

Posted on Apr 10, 2025 11:26 AM

Reply

Answer 1

Top-ranking reply

Camelot

Level 9

58,299 points

Apr 10, 2025 12:39 PM in response to brother8172

On their own, AND() and OR() are tricky enough, but combining them? I think there's a special level of **** reserved just for that...

It helps to break the steps down..

> IF one or both are are True (checked)

That would be:

=OR(A2,C2)

that will return TRUE if either A or B (or both) are checked,

Now we also:

> then check E,

That can be done with a simple:

=E2=""

which will return TRUE or FALSE depending on whether E2 is empty

Those are our two checks. So now we want to check if A2/B2 are set, AND if E is empty, so we can incorporate the AND() check:

IF(AND(OR(A2,C2),E2=""),"Entry required in Column E","")

so there you have it

Reply

Answer 2

brother8172 Author

Level 1

4 points

Apr 10, 2025 12:56 PM in response to Camelot

Camelot,

Thank you. I appreciate you providing the instructions (step-by-step); it makes much easier to understand.

Reply