Workday Error #VALUE!
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
|