If and formula with dates

[CookieMonster76]

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

 

[jasonb75]

The forum software has broken your formula, you will need to insert spaces before and after the < and > symbols to prevent it from happening.

 

[CookieMonster76]

Thanks

The formula I am trying to make work is:

=IF(AND(SUM(I64:I65)>20000,H7 > I7),0,-A3)

Where I7 and h7 are dates, with I7 being the earliest

If i put H7 > I7 in a separate cell it returns true or false depending which way around it is.

I basically need it to return the value in A3 if H7 is a later date than I7.

Thanks

Paul

 

[jasonb75]

How does SUM() > 20000 fit into it?

Because you're using AND() both criteria must be true to return 0, so if the sum is < 20000 then the result will always be false regardless of the dates.

Maybe you need OR or XOR instead of AND?