nested if function

[e_sauven]

Hi

I am having a bit of trouble with my nested if statement. I seem to have got most the way.



I am trying to say if one cell is less than 11 and another cell is less than 6, return yes, otherwise no.
I am using the formula =IF(M2>11,yes,IF(I2<6,"yes","no"))


Which works until I get a result in the first column which is greater than 11 it returns #NAME?

Any help greatly appreciated!
thanks
Emilie

 

[Andrew Poulsom]

You need to enclose the first yes in double quotes.

 

[VoG]

Try

=IF(AND(M2>11,I2< 6),"Yes","No")

 

[e_sauven]

Great thanks guys! Very helpful!