Function or If statement help

K

KrissyiP

I need to input a function or if statement that will perform the following
function:

If cell J27 contains the text "Y" complete this formula
(=NETWORKDAYS($C26,$E26,$D$85:$E$85)-1) in cell F27, if J27 is any other
letter cell F27 should remain blank

Also if cell J27 contains text "N" complete this formula
(=NETWORKDAYS($C26,$E26,$D$85:$E$85)-1) in cell G27, if J27 is any other
letter cell G27 should remain blank

The cells in the networkdays formula are all dates. The formula or function
will be used in a large column so cell numbers at each row will be different.

Any help would be appreciated
 
F

Fred Smith

In F27, enter:
=if(J27="Y",NETWORKDAYS($C26,$E26,$D$85:$E$85)-1,"")

In G27, enter:
=if(J27="N",NETWORKDAYS($C26,$E26,$D$85:$E$85)-1,"")

Just copy this down the column. If you need more help, post back.

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

Top