=IF(OR(TODAY()<G9,TODAY()>G9),"Pass","Overdue") Why doe it not wo.

C

CLR

Or this..........

=IF(AND(TODAY()>G9,H9<>"PAID"),"Overdue","Pass")

Vaya con Dios,
Chuck, CABGx3
 
K

Kassie

It does not work, because your argument is flawed. Is this what you want to
achieve?

If G9<Today(), you want the result "Overdue"
If G9>Today(), you want the result "Pass".
What if G9=Today()?

=IF(G9<TODAY(),"Overdue",IF(G9>TODAY(),"Pass","")) will work better.
 
Top