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

Leaving a cell blank when there is an error message - HELP
 

=if(iserror(IF(J2-I2<0,"",J2-I2)),"", J2-I2)

"mercedes" wrote:

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

Leaving a cell blank when there is an error message - HELP
 

try
=if(or(iserror(j2-i2),j2-I2<0),"",J2-I2)

"mercedes" wrote:

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

Leaving a cell blank when there is an error message - HELP
 

=IF(ISTEXT(J2),"",IF(J2-I2<0,"",J2-I2))

"mercedes" wrote:

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

Leaving a cell blank when there is an error message - HELP
 

Hi,

Why you have to enter a text instead of date? if you can leave it blank you
have to use this formula: =if(isblank(I2),"",IF(J2-I2<0,"",J2-I2)) but if you
can not leave the cell blank and should to enter a text in it then you have
to use this formula: =if(iserror(J2-I2),"",IF(J2-I2<0,"",J2-I2)).

ps: in the first formula i assumed that the cell I2 is the end date

Thanks,
--
Farhad Hodjat


"mercedes" wrote:

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