Calculate only if...

  • Thread starter cribology - ExcelForums.com
  • Start date
C

cribology - ExcelForums.com

Hi

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

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

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

mcpie

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(...
 
B

Bob Phillips

As NETWORKDAYS($D3,$F3)=1 will only be true if D3 and F3 are the same date,
why not use $D3=$F3
 
Top