Need help with formula
I need some help with this formula
=IF(A2=0,"",IF(J2=TODAY(),"Due
Today",IF(J2<TODAY(),"Overdue",(IF(K2<=J2,"Ontime" ,IF(K2J2,"Late"))))))
the value does not change to "ontime" or "late" when I put in the
appropriate date. What did I do wrong.
|