Function or If statement help

  • Thread starter Thread starter KrissyiP
  • Start date Start date
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
 
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
 
Back
Top