Multiple Conditions Using Multiple Values

[davo1224]

Hi Excel Forum,

I was wondering if anyone could help. I have two values for which a couple of conditions need to be met for there to then be an end result. Sorry if that sounds poorly worded.

Using specifics, (I'm using the letter O, not the number 0)

If T= 1 and O is less than 4, then I need "N" to appear.
If T= 2 or 3, and O is less than 3, then I need "N" to appear.
If T= 4, and O is less than 1, then I need "N" to appear.
Otherwise if none of these conditions are met, I need "Y" to appear.

I'm getting stuck on where to include the desired value if the multiple IF statements are true. Could anyone help me out please? Thanks in advance.

 

[anglais428]

=if(and(t1=1,o1<4),"n",if(and(or(t1=2,t1=3),o1<3),"n",if(and(t1=4,o1<1),"n","y")