Posted to microsoft.public.excel.worksheet.functions

Andis Cirulis Andis Cirulis is offline

external usenet poster

Posts: 2

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
MS Excel should handle dates before 1900!	skoalguy	Excel Discussion (Misc queries)	3	July 14th 06 04:58 PM
Fill Handle	Bob Umlas, Excel MVP	Excel Discussion (Misc queries)	0	March 28th 06 04:48 PM
Fill handle formula	neeraj	Excel Worksheet Functions	9	September 13th 05 01:46 AM
Fill Handle Across Columns	SenojNW	Excel Discussion (Misc queries)	4	August 8th 05 07:23 PM
3-d reference not adjusting when using Fill Handle to copy down	gall	Excel Worksheet Functions	3	November 24th 04 06:42 PM

All times are GMT +1. The time now is 08:14 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us