I want a formula that that looks at the results in column A and column B and based on those results puts a 0, 1 or 2 in column C
If Score in A = Score in B then put a 1 in C
If Score in A < Score in B then put a 0 in C
If Score in A > Score in B then put a 2 in C
I’ve sorted out the formula for the above BUT I also want to have column C display 0 to start with.
As it stands at the moment it displays a “1” in column C before anything is entered in A or B because the criteria in A = B is true with both equalling “0”.
Do I need something like IF A = 0 AND B = 0 THEN C = 0?
If so, how do I write the syntax for the full formula?
Pretty basic but I’m new to Excel!
Bookmarks