If Formula - checking the same cell for different entries
Hi
I have the following formula: =IF('April 2009'!K90.25,"A",IF('April 2009'!L9=ML,"ML",IF('April 2009'!L9=SL,"SL",IF('April 2009'!L9=CL,"CL",IF('April 2009'!N90.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 -- Ann |
If Formula - checking the same cell for different entries
If your checking for text values, you need to put quotes around them.
=IF('April 2009'!K90.25,"A",IF('April 2009'!L9="ML","ML",IF('April 2009'!L9="SL","SL",IF('April 2009'!L9="CL","CL",IF('April 2009'!N90.25,"T",""))))) "Ann" wrote: Hi I have the following formula: =IF('April 2009'!K90.25,"A",IF('April 2009'!L9=ML,"ML",IF('April 2009'!L9=SL,"SL",IF('April 2009'!L9=CL,"CL",IF('April 2009'!N90.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 -- Ann |
All times are GMT +1. The time now is 02:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com