if(
Posted by John on November 18, 2001 12:47 PM
Here is the problem (a1) is a date 1/1/2001
In B1 I have the formula =if (A1>=1,A1+285,0)
If there is a date in (a1) it returns the right answer if there isn't a date in there it gives me #name? why? I want it to give me 0
Please help
Posted by john sane question more info on November 18, 2001 1:55 PM
Posted by Aladin Akyurek on November 18, 2001 2:18 PM
What is "the right answer" that then returns?
And what is it that you're trying to achieve? Please in plain English if possible.
:: if there isn't a date in there it gives me #name? why? I want it to give me 0
Posted by Gary Hewitt-Long on November 18, 2001 3:44 PM
I am not quite sure what you mean? Do you mean there if there is no value in A1 at all, i.e. it is empty?
Have you tried making the final argument in your formula text (=if (A1>=1,A1+285,"0")
if it is empty use the ISEMPTY function first.
If it something else, have you tried using the ISERROR funtion first?
HTH
Regards,
Gary Hewitt-Long
