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!!!
|