multiple if statements

[Kwray]

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

 

[David Biddulph]

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

 

[Mike H]

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]

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,Holidays)),IF(B5<=A5,"ERROR")))

 

[Kwray]

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,Holidays)),IF(B5<=A5,"ERROR")))

 

[Kwray]

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,Holidays)),IF(B5<=A5,"ERROR")))

 

[David Biddulph]

=IF(OR(C1="",B1=""),0,IF(C5>=A5,"NA",IF(B5>=A5,NETWORKDAYS(A5,B5,Holidays),IF(B5<=A5,"ERROR"))))