| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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") |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF statement inside a SUMIF statement.... or alternative method | Excel Worksheet Functions | |||
| Reconcile Bank statement & Credit card statement & accounting data | Excel Worksheet Functions | |||
| Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
| Sum if statement with a left statement | Excel Discussion (Misc queries) | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
Hybrid Mode
