CookieMonster76
Board Regular
- Joined
- Apr 30, 2015
- Messages
- 195
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 way round and "TRUE" for the other.
How do i make it so it does the calculation and takes into account the dates?
Thanks
Paul
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 way round and "TRUE" for the other.
How do i make it so it does the calculation and takes into account the dates?
Thanks
Paul