I have 3 date columns (Columns A, B, C) and I need one formula (Column D) to
return the following all inclusive result. I can get some of it to work but
no all. HELP! And thanks.

IF B1=A1 =NETWORKDAYS
IF C1=A1 =NA
IF B1<A1 =ERROR
IF C1 OR B1 is blank =0

Nest the IF statements (once you've decided what precedence you want between
the conditions).
--
David Biddulph

"Kwray" wrote in message
...
I have 3 date columns (Columns A, B, C) and I need one formula (Column D)
to
return the following all inclusive result. I can get some of it to work
but
no all. HELP! And thanks.

IF B1=A1 =NETWORKDAYS
IF C1=A1 =NA
IF B1<A1 =ERROR
IF C1 OR B1 is blank =0

Hi,

Unless I've misunderstood, you can't do that because the logic is flawed.
For example

B1=A1 =Networkdays
C1=A1 =NA

Both of those conditions could be true at the same time in which case what
would the formula return?

Pehaps you could give a fuller explanation and then I'm sure someone will
help.

Mike

"Kwray" wrote:

I have 3 date columns (Columns A, B, C) and I need one formula (Column D) to
return the following all inclusive result. I can get some of it to work but
no all. HELP! And thanks.

IF B1=A1 =NETWORKDAYS
IF C1=A1 =NA
IF B1<A1 =ERROR
IF C1 OR B1 is blank =0

I've nested the statement and the first three situations work (see below).
But I can't figure out the precedence to get the last situation to work.

=IF(C5=A5,"NA",IF(B5=A5,(NETWORKDAYS(A5,B5,Holid ays)),IF(B5<=A5,"ERROR")))

"Kwray" wrote:

I have 3 date columns (Columns A, B, C) and I need one formula (Column D) to
return the following all inclusive result. I can get some of it to work but
no all. HELP! And thanks.

IF B1=A1 =NETWORKDAYS
IF C1=A1 =NA
IF B1<A1 =ERROR
IF C1 OR B1 is blank =0

I've nested the statement and the first three situations work (see below).
But I can't figure out the precedence to get the last situation to work.

=IF(C5=A5,"NA",IF(B5=A5,(NETWORKDAYS(A5,B5,Holid ays)),IF(B5<=A5,"ERROR")))


"Mike H" wrote:

Hi,

Unless I've misunderstood, you can't do that because the logic is flawed.
For example

B1=A1 =Networkdays
C1=A1 =NA

Both of those conditions could be true at the same time in which case what
would the formula return?

Pehaps you could give a fuller explanation and then I'm sure someone will
help.

Mike

"Kwray" wrote:

I have 3 date columns (Columns A, B, C) and I need one formula (Column D) to
return the following all inclusive result. I can get some of it to work but
no all. HELP! And thanks.

IF B1=A1 =NETWORKDAYS
IF C1=A1 =NA
IF B1<A1 =ERROR
IF C1 OR B1 is blank =0

I've nested the statement and the first three situations work (see below).
But I can't figure out the precedence to get the last situation to work.

=IF(C5=A5,"NA",IF(B5=A5,(NETWORKDAYS(A5,B5,Holid ays)),IF(B5<=A5,"ERROR")))


"David Biddulph" wrote:

Nest the IF statements (once you've decided what precedence you want between
the conditions).
--
David Biddulph

"Kwray" wrote in message
...
I have 3 date columns (Columns A, B, C) and I need one formula (Column D)
to
return the following all inclusive result. I can get some of it to work
but
no all. HELP! And thanks.

IF B1=A1 =NETWORKDAYS
IF C1=A1 =NA
IF B1<A1 =ERROR
IF C1 OR B1 is blank =0

=IF(OR(C1="",B1=""),0,IF(C5=A5,"NA",IF(B5=A5,NET WORKDAYS(A5,B5,Holidays),IF(B5<=A5,"ERROR"))))
--
David Biddulph

"Kwray" wrote in message
...
I've nested the statement and the first three situations work (see below).
But I can't figure out the precedence to get the last situation to work.

=IF(C5=A5,"NA",IF(B5=A5,(NETWORKDAYS(A5,B5,Holid ays)),IF(B5<=A5,"ERROR")))

"Kwray" wrote:

I have 3 date columns (Columns A, B, C) and I need one formula (Column D)
to
return the following all inclusive result. I can get some of it to work
but
no all. HELP! And thanks.

IF B1=A1 =NETWORKDAYS
IF C1=A1 =NA
IF B1<A1 =ERROR
IF C1 OR B1 is blank =0