If Formula - checking the same cell for different entries

[Ann]

Hi

I have the following formula:

=IF('April 2009'!K9>0.25,"A",IF('April 2009'!L9=ML,"ML",IF('April
2009'!L9=SL,"SL",IF('April 2009'!L9=CL,"CL",IF('April
2009'!N9>0.25,"T","")))))

But I can only get it to return the 'A' or 'T'. It won't return 'ML', 'SL'
or 'CL', the only reason I can think of is that it's searching the same cell
3 times to check for this info?

Any help would be gratefully received!

Thanks

 

[RonaldoOneNil]

If your checking for text values, you need to put quotes around them.
=IF('April 2009'!K9>0.25,"A",IF('April 2009'!L9="ML","ML",IF('April
2009'!L9="SL","SL",IF('April 2009'!L9="CL","CL",IF('April
2009'!N9>0.25,"T","")))))