| Home |
| Search |
| Today's Posts |
|
#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. |
| 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 | |||
Threaded Mode
