Workday Error #VALUE!

T

Tufail

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.
 
D

Dave O

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

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
 
T

Tufail

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

Fred Smith

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

Regards,
Fred
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF formula 1
VBA Coding Help for Beginner 0
Help using the Workday Function 1
Adding Network Trusted Location on MS O365 Word per Computer Registry Setting 1
Drop down list control value in vba 2
How to shift a weekend date to the last or next workday 2
how to convert grades into a value 5
VBA - exporting serial letters to single documents 0

Top