Thread: Don't run formula if cell is blank
View Single Post
  #2   Report Post  
wickedchew wickedchew is offline
Senior Member
  
Location: Philippines
Posts: 161
Default
Quote:
Originally Posted by Randy Mis View Post
I have a formula for tracking completion dates that works great, but if the cell is blank the formula sends back date showing the item is over due. How do I get the formula to not run if the cell is blank?

=IF($E3<TODAY(),TODAY()-$E3&" Days Overdue","")

Cell e3 is the date the item is due.
=IF($E3="","",IF($E3<TODAY(),TODAY()-$E3&" Days Overdue",""))
__________________
Asobi Wa Owari Da
Reply With QuoteReply With Quote