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!

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



Tony S. wrote:

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!

--

Dave Peterson

Try:
=IF(ISERROR(FIND("(R(9997 - 9998)",F3)),"",FIND("(R(9997 - 9998)",F3)-1)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"Tony S." wrote:
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!

You guys nailed it... Thanks Max and Dave. I appreciate your help.
Tony

"Dave Peterson" wrote:

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



Tony S. wrote:

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!

--

Dave Peterson