If, Or, And

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.

Find more posts tagged with

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

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

That worked, Thanks a ton

How do I create a Folder under a Sheets
So I am new to Smart Sheets but need to know how I create a Folder under the sheets section as shown by someone who was managing this before? Please if possible reply to kirk@ship-sts.com since I am taking over this Smartsheet but allowing the current owner to transition before I update credentials.
Mystery added columns
I came back from vacation to find that about 20 columns, with headers but no data, have mysteriously added themselves to my Smartsheet. I created this version by using an older sheet as a template 3 years ago and streamlined by deleting a lot of excessive information tracking columns. And I use some hidden columns, so…
How do I update the content that displays when a user selects "Send me a copy of my responses"
When a user submits our form they can select the option to get a copy of their responses. The email they receive has some major formatting issues that need to be resolved - specifically our institution's logo is enormous in the email. Where can I edit the template for people who have elected to get a copy of their…