IF(ISERROR problem

T

Tony S.

Please help me with my formula to eliminate the "#VALUE"

=FIND("(R(9997 - 9998)",F3)-1

When I try to add =IF(ISERROR to this formula, I alway get a error or
missing parens or formula to short or contains an error. I know it's my
syntax but I can figure out where.

Thanks!
 
D

Dave Peterson

=if(isnumber(find("...",f3)),find("...",f3)-1,"not found")
or
=if(iserror(find("...",f3)),"not found",find("...",f3)-1)
 
D

Dave Peterson

=if(isnumber(find("...",f3)),find("...",f3)-1,"not found")
or
=if(iserror(find("...",f3)),"not found",find("...",f3)-1)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

iserror problem 9
adding =if(iserror to formula 6
Formula error 1
Overwriting #DIV/0 value using ISERROR 3
nested IF(ISERROR()) statement 13
ISLOGICAL function 7
Iserror 2
hiding an error value, using INDEX/MATCH 3

Top