If, Or, And

michael.vanhuss

I'm trying to work an if/or/and statement to return one of 2 numbers. It would look something like,

 If X or Y or Z and A or B then 0 else 8.

It has me completely stumped my results are always unparsable. Do anyone have a direction to point me in?

Any help would be greatly appreciated.

Debbie Sawyer

Is the XY or Z in one cell and the Aor B in another cell?

Debbie Sawyer

Try this:

=IF(AND(OR([Result1]@row = "X", [Result1]@row = "Y", [Result1]@row = "Z"), OR([Result2]@row = "A", [Result2]@row = "B")), 0, 8)

Where Result1 is the name of the column which might contain an X Y or Z and where Result2 is the name of the column which might contain an A or B

Hope this helps

​Debbie Sawyer Consultant & Training Manager

 

 

michael.vanhuss

That worked, Thanks a ton