View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default 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