Excel 97 - simple logical function that I can't figure out

  • Thread starter Thread starter Lyn Kimes
  • Start date Start date
L

Lyn Kimes

I need to check cells A5 and A8 and enter "-5" if A5 is
greater that A8, a "+5" if it is smaller than A8, and
a "0" if they contain the same value.

Well, it works if I put in: =IF(A5>A8,-5,+5)
but I don't know how to get
it to put in the zero if
they are the same.

Can anyone help me? I suspect I need to use the OR somehow
but I don't know how.

Thanks for your help
 
Back
Top