If then statement

S

scottay

I am trying to do a formula that searches a cell for the letters "FHA" then
the result is FHA. If the cell contains anything other than "FHA" then the
result is Conv. If the cell is blank then result in blank.
=IF(ISNUMBER(SEARCH("FHA",G11)),"Gov", "Conv")

Thanks for your help.
 
M

Max

Listening to your specs, something like this should do:
=IF(G11="","",IF(ISNUMBER(SEARCH("FHA",G11)),"FHA","Conv"))
Success? celebrate it, hit the YES below
 
Top