Stuck with simple IF condition
I am using the following simple formula:
IF A2>B2"( + )""( - )"
I am using this in a table within Word document. Let's say I am comparing value (numbers) in column "A" with value in column "B", I want to determine if the value in column "A" is greater than value in column "B", if so I want to show a "+" sign in column "C", otherwise it should be "-" sign.
But this is not the case. Even if I have smaller value in column "A", the above formula is still giving me "+" sign which is wrong.
Any idea how to fix this error?
Thanks in advance.