Value error on OR command

V

#VALUE! Error

I have unput the following formula and instead of getting
a false I get a #VALUE! error. Returns true statement if
both are true. Does anyone know why this is happening.
Seems pretty straightforward. Does not matter if I use
find or findb


=OR(FINDB("ISO",G2),FINDB("CAN",G2))
 
P

Peo Sjoblom

Because findb or find return an error if they cannot find the string, wrap
both findb formulas with isnumber like

=OR(ISNUMBER(FINDB.....),ISNUMBER(FINDB.....))
 
G

Guest

I'll try and let you know. Thanks
-----Original Message-----
Because findb or find return an error if they cannot find the string, wrap
both findb formulas with isnumber like

=OR(ISNUMBER(FINDB.....),ISNUMBER(FINDB.....))

--

Regards,

Peo Sjoblom





.
Click to expand...
 
G

Guest

It worked. Thanks
-----Original Message-----
Because findb or find return an error if they cannot find the string, wrap
both findb formulas with isnumber like

=OR(ISNUMBER(FINDB.....),ISNUMBER(FINDB.....))

--

Regards,

Peo Sjoblom





.
Click to expand...
 
B

Bob Phillips

Try this instead

=OR(NOT(ISERROR(FIND("ISO",G2))),NOT(ISERROR(FIND("CAN",G2))))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top