S
Stinky
I'm trying to do a logical test that uses dates. If I use > it returns the
correct result, but if I use = or < I get the wrong result:
A B C
1 25/03/2010 500 0
2 24/03/2010 300 0
3 27/03/2010 750 750
In C1 the formula is =IF(A1=25/3/2010,K32,0) which I would expect to be true
and return 500, but it returns the false value
In C2 the formula is =IF(A2<25/3/2010,K33,0) which I would expect to be true
and return 300, but it returns the false value
In C3 the formula is =IF(A3>25/3/2010,K34,0) which is true and returns the
correct value.
Can anyone help?
correct result, but if I use = or < I get the wrong result:
A B C
1 25/03/2010 500 0
2 24/03/2010 300 0
3 27/03/2010 750 750
In C1 the formula is =IF(A1=25/3/2010,K32,0) which I would expect to be true
and return 500, but it returns the false value
In C2 the formula is =IF(A2<25/3/2010,K33,0) which I would expect to be true
and return 300, but it returns the false value
In C3 the formula is =IF(A3>25/3/2010,K34,0) which is true and returns the
correct value.
Can anyone help?