Excel Function return a certain value if citeria x is met

G

Guest

Hi,
I have the following function
=IF(C13=0,(WORKDAY(D13,0)),(WORKDAY(D13,C13-1)))
and I have a column that has "x", which meant it is completed.
I want to write a function that will help me reference the formula so that
if the column does have an x then the above function answer should appear,
otherwise i want it to be blank.
 
G

Guest

Let's say the column with the x'xs is column X:

=IF(X13="x",IF(C13=0,(WORKDAY(D13,0)),(WORKDAY(D13,C13-1))),"")
 

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

Top