Calculate only if...

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

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,+NETWORKDAYS($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?
>
>

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

--
HTH

Bob Phillips

"mcpie" <[email protected]> wrote in message
news:[email protected]...
> 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,+NETWORKDAYS($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?
> >
> >