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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

isnumber search 4
Sumproduct Excluding Data 2
Sequencing parts 11
Insert name and adress from a list in a word document 1
How To Have A Cell Be Blank If... 2
need help in fine-tuning a formula that removes blank cells in a column range 3
Multiple IF Statements 8
Newbie Help - IF Yes No Function 0

Top