View Single Post
  #3   Report Post  
mcpie
 
Posts: n/a
Default

try
=IF(AND($D3=0,$L3=0),"",OR(NETWORKDAYS($D3,$F3)=1, +NETWORKDAYS($D3,$F3)=2))

where the AND(... formula works in the same way as OR(...

"cribology - ExcelForums.com" wrote:

Hi,

I currently have a spreadsheet that has this formula in the Q column.

=IF($D3=0,"",OR(NETWORKDAYS($D3,$F3)=1,+NETWORKDAY S($D3,$F3)=2))

It only calculates the networkdays if D3 is empty, but now I would
like it to calculate networkdays if both D3 and L3 is empty. How do I
adjust the formula to check the additional L3 cell?