Nested AND & OR Conditionals in a Formula

[flyersfansince87]

Hello,

My company sells artwork and we got a new printer which can print maximum dimensions of 40x56 inches. That can be laid out as either 40x56 for portrait, or 56x40 for landscape format.

Anything bigger than either dimension cannot work. We have over 50,000 prints in our library that were sized for our old printer, so we have to identify which ones have to be re-sized for the new on.

Basically I need to be able to read 2 Excel columns and tell if a print is "OK" or "TOO BIG" so that we can resize them if needed.

The dimensions are listed in Columns A and B

L W RESULTS

39 56 OK
40 55 OK
40 56 OK
41 56 TOO BIG
40 57 TOO BIG


Here is the logic (not the actual formula - I tried so many and junked them all)

IF A2<=40, and B2<=56 then C2="OK". IF else, C2="TOO BIG"
IF A2<=56, and B2<=40 then C2="OK", IF else, C2="TOO BIG"

I've been trying to figure this out for about 3 hours now, and I can't get things properly nested no matter what I try.

Can someone please kindly get me pointed in the right direction please?

Thank you so much for your time.

Best,
Joe C.

[AliGW]

Try this:

=IF(AND(A2<=40,B2<=56),"OK",IF(AND(A2<=56,B2<=40),"OK","TOO BIG"))

[FDibbins]

Hi and welcome to the forum

Not sure if this will work for you or not....
=IF(AND(A2<=56,B2<=56),"OK","TOO BIG")

[AliGW]

Hi and welcome to the forum

Not sure if this will work for you or not....
=IF(AND(A2<=56,B2<=56),"OK","TOO BIG")

No, it won't. The maximum dimensions the printer can handle are 40" x 56".

[flyersfansince87]

Thank you so much for the help. I would have floundered aroudn with that for like 5 more hours and still probably not solved it.

That's why I joined this forum over the others.
You guys are great.

[AliGW]

You are welcome!