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