Multiple if and or conditions

[sopedrulka]

Hey all,

I need help to come up with a formula that includes multiple IF AND OR conditions and Im not sure where to start.

The conditions are

if (A2>1 and B2<1 and C2<1) OR (A2<1 and B2<1 and C2<1) OR (A2<1 and B2>1 and C2>1) OR (A2<1 and B2>1 and C2<1) then 1
if (A2>1 and B2>1 and C2<1) OR (A2>1 and B2<1 and C2>1) then 2
if (A2>1 and B2>1 and C2>1) then 3

[bebo021999]

So, If A2<1 then always 1 regardless B2 and C2?

Please Login or Register  to view this content.

[TMS]

This is the answer to your question though the previous solution provides the same result much more efficiently.

Please Login or Register  to view this content.

[sopedrulka]

Thank you, it worked

[sopedrulka]

Hello, unfortunately we have one case where A2 is not always <1
thank you anyway!

[bebo021999]

What is your new condition if A1>=1 and A1<1?