View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
KrissyiP KrissyiP is offline
external usenet poster
 
Posts: 1
Default Function or If statement help

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