Hi
I have the following
=IF(AND(SUM(H64:H65)>20000,H7<I7),0,A3)
where H7 and I7 are dates, and H7 is earlier then I7
Whichever way around I put the "<" or ">", the formula never returns zero, always returns the value in cell A3.
If i put = H7<I7 into a different cell it returns FALSE for one...