Countif and/or

[AdamJones]

Hi,

I need a formula which can do the following
The cell containing the formula should equal 1 if:
A-B is positive AND C-D is positive, OR;
A-B is negative AND C-D is negative, OR;
A-B is 0 AND C-D is 0
The cell should equal 0 otherwise.

I've tried what I know but cant quite figure it out.
Thanks

 

[wideboydixon]

If the values are in A1, B1, C1 and D1 then enter the following in E1:

=IF(SIGN(A1-B1)=SIGN(C1-D1),1,0)

WBD