Value error on OR command

[#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))

 

[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.....))

 

[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





.

 

[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





.

 

[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)