IF OR ISERROR problem

[jomili]

Okay, my formula doesn't work, and I'm at a loss. Here's what I want to do:

IF O2 minus J2 is an error (because there's no values in O2 or J2), OR if O2 minus J2 is Zero or less, don't show anything. Otherwise, show the results of O2-J2. Code is below, but I've got something hosed and can't figure out what. Any help would be appreciated.

=IF((OR(ISERROR(O2-J2),O2-J2<=0)),"",O2-J2)

[DonkeyOte]

Given the explicit coercion taking place as a result of the subtraction you need to test the Error first / separately:

=IF(ISERROR(O2-J2),"",IF(O2<=J2,"",O2-J2))

we don't know how O2:J2 are being populated but you might find you could get away with:

=IF(OR(COUNT(O2:J2)<2,O2<=J2),"",O2-J2)

but the former is more "robust"

[jomili]

Thanks DonkeyOte;

I hadn't even thought about splitting it up like that. I appreciate the help.