Ignoring blank cells in OR formula

[MGIRC]

In Excel 2013, I have a formula similar to this:

=IF(OR(C2>B2, C2>A2, B2>A2),1)

I want to return 1 if any of the inequalities is true. But if one of the cells in my OR statement is blank, I don't want the formula to treat the blank as zero and evaluate but instead read false and move on to the next inequality.

I have searched quite a bit through IFBLANK and IFNUMBER but still not getting this right--help would be very much appreciated. Thanks.

 

[Eric W]

Yoicks! The BB truncated part of my formula. It should be:

=IF(SUMPRODUCT(--(A2:C2<>""),--(A2:C2 < A1:C1)),1)

I should have learned by now to watch for that.