| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Checking Column Entries | Excel Worksheet Functions | |||
| Checking for specific entries in a column | Excel Discussion (Misc queries) | |||
| Checking entries against a column of data | Excel Discussion (Misc queries) | |||
| Checking for double entries | Excel Discussion (Misc queries) | |||
| Checking for duplicate entries | Excel Discussion (Misc queries) | |||
Linear Mode
