IF AND Formula

[feature]

I am trying to use an IF AND formula

This is want I want to do:

If (G2-F2) is <0 and if (H2) is also <0, I want it to output a 1

and

If (G2-F2) is >0 and if (H2) is also >0, I want it to output a 1

else, I want it to output a 0.

How can I write this into a formula?

Thanks!

[Jonmo1]

Try

=--OR(AND(G2-F2<0,H2<0),AND(G2-F2>0,H2>0))

[martindwilson]

=if(and(g2-f2<0,h2<0),1,if(and(g2-h2>0,h2>0),1,0)

[Jonmo1]

Here's another way, but it's making an assumption..

You specified >0 and <0.
but didn't say anything about exactly 0

If both (H2 and G2-F2) are 0, should it still be a 1 ?
If so, then you can use
=--(SIGN(H2)=SIGN(G2-F2))

[feature]

Thanks for the prompt response, it worked great

=if(and(g2-f2<0,h2<0),1,if(and(g2-h2>0,h2>0),1,0)