View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Another If Formula Question

Try this:

=IF(OR(A1="",A1=B1),"Overdue","")

--
Biff
Microsoft Excel MVP


"loomie" wrote in message
...
Okay the if formula below that was given works great thanks!

With dates in a1 & B1 try this

=IF(A1=B1,"Overdue","")


However,if the date is blank it also returns false. How do I exclude blank
or make blank also overdue?