Thread: If Formula
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default If Formula

Change the cell addresses of A1 and B1 to your date value cells:

=IF(A1<=B1,"Overdue","")
--
Kevin Backmann


"loomie" wrote:

Can anyone help me out with a formula that would do the following in excell:


If date X = to or less than date X, result shows overdue