Hi, first time I have used this forum so hope this makes sense.


I have a spreadsheet that I want to be able to give me 3 different answers to.

column A = 17
column B = 20
Column C, I want this to give me a 0 if column A & B are the same, a 1 if A is greater than B and 2 if A is less than B. I can do the greater than or less than but can't work out how to input an answer if they are the same, for example they both say 20 = 0

Any help would be great.