Formula not working

[coleyoder]

I put this formula in my spreadsheet to help put "pass" or "passes" according to the number on the cell I chose to use.

here is the formula:

=IF(M2="1","Pass",IF(M2="2","Passes",IF(M2="3","Passes",IF(M2="4","Passes",IF(M2="5","Passes",IF(M2="6","Passes",IF(M2="7","Passes",IF(M2="8","Passes",IF(M2="9","Passes",IF(M2="10","Passes",IF(M2="11","Passes",IF(M2="12","Passes",IF(M2="13","Passes",IF(M2="14","Passes",IF(M2="15","Passes",IF(M2="16","Passes",IF(M2="17","Passes","")))))))))))))))))


If anyone sees anything wrong or can help me understand why it isn't working that would be greatly appreciated.

 

[gaz_chops]

Does M2 contain text?

 

[Fluff]

If M2 is a number then you need to remove the quotes around "1", "2" etc.
Another way of doing it would be
=IF(M2=1,"Pass",IF(AND(M2>1,M2<=17),"Passes",""))

 

[gaz_chops]

Or

=IF(M2=1, "Pass",IF(M2 < 18,"Passes",""))

 

[AlanY]

how about

=if(M2=1,"Pass",if(M2<=17,"Passes",""))

 

[coleyoder]

If M2 is a number then you need to remove the quotes around "1", "2" etc.
Another way of doing it would be
=IF(M2=1,"Pass",IF(AND(M2>1,M2<=17),"Passes",""))

Figured it out everyone!

Thanks for the advice it was super helpful

 

[Fluff]

Glad it's sorted & thanks for the feedback