Hi guys,
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.
Syed