Can I use OR with iserror for multiple checking?

[CAQ]

Got a problem need to check three logics with ISERROR (to check data on two different sheets and checking if one for negative value.
I'm not sure if I can use an OR statement to combine all three queries.

=IF(OR((ISERROR(VLOOKUP($A1,Sheet1!$1:$4600,2,FALSE)),ISERROR(VLOOKUP($A1,Sheet2!$1:$4600,2,FALSE)),VLOOKUP($A1,Sheet1!$1:$4600,2,FALSE)<0)),0,PERFORM SOME CALCULATION)))

 

[HiTechCoach]

This looks like Excel not Access code. Since this is not in the Excel forum, but an Access forum, can you clarify what app this is for?

 

[CAQ]

My goof I didn't realized. I'll move on.

 

[stopher]

Yes you can use OR to check several booleans. To convince yourself, try entering this in a cell:

=OR(true,true,false)

It might be my eyesight but your brackets don't match up.

Chris

 

[CAQ]

Got it thanks.