Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Find and IF statement
Hi:
I am using following formula to search a string and display in target cell, if first IF condition returns TRUE it displays BCOT, if not #value! error. any help. =IF(SEARCH("BCOT",A2)0,"BCOT",IF(SEARCH("BCPN",A2 )0,"BCPN","")) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible to find which sql statement is running? | Charts and Charting in Excel | |||
If statement to find NA() | Excel Worksheet Functions | |||
If statement to find NA() | Excel Worksheet Functions | |||
How do I use an if statement with Find and Replace | Excel Worksheet Functions | |||
Can't find logical_test for "if"statement | Excel Worksheet Functions |