multiple if statements

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

Signature

David Biddulph

>I have 3 date columns (Columns A, B, C) and I need one formula (Column D)
>to
[quoted text clipped - 6 lines]
> IF B1<A1 =ERROR
> IF C1 OR B1 is blank =0

Reply to this Message

Kwray - 10 May 2008 16:03 GMT

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")))

> Nest the IF statements (once you've decided what precedence you want between
> the conditions).
[quoted text clipped - 8 lines]
> > IF B1<A1 =ERROR
> > IF C1 OR B1 is blank =0

Reply to this Message

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

> 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
[quoted text clipped - 4 lines]
> IF B1<A1 =ERROR
> IF C1 OR B1 is blank =0

Reply to this Message

Kwray - 10 May 2008 16:03 GMT

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")))

> Hi,
>
[quoted text clipped - 20 lines]
> > IF B1<A1 =ERROR
> > IF C1 OR B1 is blank =0

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

> 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
[quoted text clipped - 4 lines]
> IF B1<A1 =ERROR
> IF C1 OR B1 is blank =0

Reply to this Message

David Biddulph - 10 May 2008 16:06 GMT

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

> 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.
[quoted text clipped - 11 lines]
>> IF B1<A1 =ERROR
>> IF C1 OR B1 is blank =0

Reply to this Message