MegaSack DRAW - This year's winner is user - rgwb
We will be in touch
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
Try changing the formula to A1-A2=0 rather than A1=A2.
Oh and are the figure EXACTLY those integers? If there are any decimals in there then this sort of comparison can be tricky to get right and you may have to use something like A1-A2 < x where x is suitably close to zero for your requirements.
in A3 type: =if(A1=A2, 1, 0)
=IF(A1=A2,1,0)
works for me
Cheers Stoner, sorted. I blame the Excel function description which says IF(logical_test,[value_if_true],[value_if_false]) with the bloody square brackets in.
Could you enter in A3 =A2=A1
This should give you a true or false result.
with the bloody square brackets in
Remove all packaging before placing pizza in the oven 😉