If then statement
 

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.

If then statement
 

One way...

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

--
Biff
Microsoft Excel MVP


"scottay" wrote in message
...
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.

If then statement
 

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
--
Max
Singapore
---
"scottay" wrote:
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")

If then statement
 

Perfect.
Thanks.

"scottay" wrote:

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.