If then statement

[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.

 

[T. Valko]

One way...

=IF(G11="","",IF(COUNTIF(G11,"*FHA*"),"FHA","Conv"))

 

[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

 

[scottay]

Perfect.
Thanks.