Hello,
I am using this formula in cell D1 =IF($A1="","",WORKDAY(B1,C1))
B_1 has Date and C-1 has credit days value like 10 and i want Due Date in
D_1 cell but problam is that whenever B_1 doesn't have any value then #VALUE!
error is coming out which i really don't want !
Thanks in advance.

One way to do it is to use an IF statement:
=IF(ISERROR(your_formula_here),"",your_formula_her e)

Plain English translation: if the formula returns an error, return a
""; if it returns a non-error result, return that result.

Dave O
Eschew Obfuscation

Dear Dave O,
Thanks for your reply, but sorry not understant well, you means formula
would be is as under ?
=IF(ISERROR(WORKDAY(B1,C1),"",WORKDAY(B1,C1))
If so then this is not working !


"Dave O" wrote:

One way to do it is to use an IF statement:
=IF(ISERROR(your_formula_here),"",your_formula_her e)

Plain English translation: if the formula returns an error, return a
""; if it returns a non-error result, return that result.

Dave O
Eschew Obfuscation

You forgot the closing parenthesis for ISERROR. Dave means:
=IF(ISERROR(WORKDAY(B1,C1)),"",WORKDAY(B1,C1))

Regards,
Fred


"Tufail" wrote in message
...
Dear Dave O,
Thanks for your reply, but sorry not understant well, you means formula
would be is as under ?
=IF(ISERROR(WORKDAY(B1,C1),"",WORKDAY(B1,C1))
If so then this is not working !


"Dave O" wrote:

One way to do it is to use an IF statement:
=IF(ISERROR(your_formula_here),"",your_formula_her e)

Plain English translation: if the formula returns an error, return a
""; if it returns a non-error result, return that result.

Dave O
Eschew Obfuscation

Oh Yes ! You are right and now it's working.
Thank you very much.

"Fred Smith" wrote:

You forgot the closing parenthesis for ISERROR. Dave means:
=IF(ISERROR(WORKDAY(B1,C1)),"",WORKDAY(B1,C1))

Regards,
Fred


"Tufail" wrote in message
...
Dear Dave O,
Thanks for your reply, but sorry not understant well, you means formula
would be is as under ?
=IF(ISERROR(WORKDAY(B1,C1),"",WORKDAY(B1,C1))
If so then this is not working !


"Dave O" wrote:

One way to do it is to use an IF statement:
=IF(ISERROR(your_formula_here),"",your_formula_her e)

Plain English translation: if the formula returns an error, return a
""; if it returns a non-error result, return that result.

Dave O
Eschew Obfuscation