if formula

Guest · Apr 18, 2007

=IF(C15>D15,-5,5)

I am using the preceding formula. How do I change it to reflect the
scenerio of "if c15=d15 than 0" ???

Thanks in advance

T. Valko · Apr 18, 2007

Try this:

=IF(C15=D15,0,IF(C15>D15,-5,5))

Biff

Guest · Apr 18, 2007

=IF(C15=D15,0,IF(C15>D15,-5,5))

JE McGimpsey · Apr 18, 2007

One way:

=5*SIGN(D15-C15)

Guest · Apr 18, 2007

Try =IF(C15>d15,-5,IF(C15=D15,0,5)