View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Roy Roy is offline
external usenet poster
 
Posts: 53
Default 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.