I thought using the IF function would be pretty straightforward.
I want to compare 2 cells, both containing numbers, and evaluate if they are equal in a 3rd cell. E.g.
| 3 | 4 | =IF(A1=A2,[1],[0] |
This example should return a 0 because 3 does not equal 4.
Can anyone see why this wouldn't work? Excel claims the formula has an error in it.
Cheers
jon

