| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with If statment
I've created this if statment, but it's not returning the the appropriate
values.....please help. Thanks. =IF(C5="801","Beaumont",IF(C5="APS803"="Lafayette" ,IF(C5="805"="Houston",IF(C5="806"="San Antonio",IF(C5="810"="Dallas",""))))) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with If statment
If your lookup values are *all* text, this should work:
=IF(C5="801","Beaumont",IF(C5="APS803","Lafayette" ,IF(C5="805","Houston", IF(C5="806","San Antonio",IF(C5="810","Dallas",""))))) When you use quotes around numbers, that makes then Text. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "pm" wrote in message ... I've created this if statment, but it's not returning the the appropriate values.....please help. Thanks. =IF(C5="801","Beaumont",IF(C5="APS803"="Lafayette" ,IF(C5="805"="Houston",IF(C5="806"="San Antonio",IF(C5="810"="Dallas",""))))) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with If statment
pm
Try this, works for me now, you have a few displaced "=" signs Mike Rogers =IF(C5="801","Beaumont",IF(C5="APS803","Lafayette" ,IF(C5="805","Houston",IF(C5="806","San Antonio",IF(C5="810","Dallas",""))))) "pm" wrote: I've created this if statment, but it's not returning the the appropriate values.....please help. Thanks. =IF(C5="801","Beaumont",IF(C5="APS803"="Lafayette" ,IF(C5="805"="Houston",IF(C5="806"="San Antonio",IF(C5="810"="Dallas",""))))) |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with If statment
Thanks Mike...it works!
"Mike Rogers" wrote: pm Try this, works for me now, you have a few displaced "=" signs Mike Rogers =IF(C5="801","Beaumont",IF(C5="APS803","Lafayette" ,IF(C5="805","Houston",IF(C5="806","San Antonio",IF(C5="810","Dallas",""))))) "pm" wrote: I've created this if statment, but it's not returning the the appropriate values.....please help. Thanks. =IF(C5="801","Beaumont",IF(C5="APS803"="Lafayette" ,IF(C5="805"="Houston",IF(C5="806"="San Antonio",IF(C5="810"="Dallas",""))))) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If statment | Excel Discussion (Misc queries) | |||
| if statment | Excel Worksheet Functions | |||
| If statment if its possible. | Excel Discussion (Misc queries) | |||
| Something is wrong with this IF statment | Excel Worksheet Functions | |||
| If statment | Excel Worksheet Functions | |||
Linear Mode
