Thread: [Solved] If formatting
View Single Post
 
Old 09-16-2014, 05:40 AM
clara1703 clara1703 is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Sep 2014
Posts: 2
clara1703 is on a distinguished road
Default If formatting

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.
Reply With Quote