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