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","")))))
|