• Notice regarding image hosts and attachments. See here.

simple excell math question

Associate
Joined
19 Jul 2006
Posts
1,847
I have 2 numbers that I want to compair im using this formular at the moment

=IF((E4+F4)<(G4+H4),1,-1)

which says if the sum of e4+f4 is greater than g4+h4 then in the cell put 1 otherwise put -1 which works fine.
But i want to expand on this i want it to be
if ((e4+f4) is larger than (g4+h4) by 10 then put 1 in the cell or
if ((ef+f4) is smaller than (g4+h4) by 10 put -1 in the cell
otherwise put 0

How do i do this in excel

TIA
 
Last edited:
Back
Top Bottom