Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
handle #VALUE exception
hey,
I`ve excel function =SEARCH("LV-1";D2) if search text LV-1 is not found - it returns #VALUE how can I handle this #VALUE ? =IF(SEARCH("LV-1";D2);"substring_found";"substring not found") is not working (#VALUE returned in false case) I believe this is simple, just cannot think of any solution.. Thanks, Andis |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
handle #VALUE exception
=IF(ISNUMBER(SEARCH("LV-1";D2));"substring_found";"substring not
found") HTH Kostis Vezerides Andis Cirulis wrote: hey, I`ve excel function =SEARCH("LV-1";D2) if search text LV-1 is not found - it returns #VALUE how can I handle this #VALUE ? =IF(SEARCH("LV-1";D2);"substring_found";"substring not found") is not working (#VALUE returned in false case) I believe this is simple, just cannot think of any solution.. Thanks, Andis |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
handle #VALUE exception
=IF(ISERROR(SEARCH("LV-1";D2));"substring not found";"substring found")
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Andis Cirulis" wrote in message ... hey, I`ve excel function =SEARCH("LV-1";D2) if search text LV-1 is not found - it returns #VALUE how can I handle this #VALUE ? =IF(SEARCH("LV-1";D2);"substring_found";"substring not found") is not working (#VALUE returned in false case) I believe this is simple, just cannot think of any solution.. Thanks, Andis |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MS Excel should handle dates before 1900! | Excel Discussion (Misc queries) | |||
Fill Handle | Excel Discussion (Misc queries) | |||
Fill handle formula | Excel Worksheet Functions | |||
Fill Handle Across Columns | Excel Discussion (Misc queries) | |||
3-d reference not adjusting when using Fill Handle to copy down | Excel Worksheet Functions |