View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mercedes mercedes is offline
external usenet poster
 
Posts: 12
Default Leaving a cell blank when there is an error message - HELP

I am keeping count of the difference in days from when we receive something
to when we quote it using the formula: =IF(J2-I2<0,"",J2-I2) since I cannot
have negative numbers running. But on some fields there is no end date so i
have to enter a text in that field (instead of a date) so in my formula
column I get an error message. I need to change the forlua to where it still
counts the way it does right now, but when there is an error I get a blank
cell instead. Please help!!
Thanks!!!