multiple Or???

[Maddyv]

A B D E F G H
1 5 0 13 15
2 0 11 15 18 14 7


H2=IF(OR(F2=0,F2="ERROR",OR(A2<A1,D2<D1)),0,(F2/G2)). Answer should be 2. Please help.

I'm having issues with "OR(A5<A4,D5<D4)". I know I'm not doing this right, but basically, I'd like the condition to also include that even if A5<A4, but not necessary D5<D4 or vice versa, I'd still like F2/G2.

[d1sturbdapeace]

Leave the second "OR" out. The format is =OR(variable1, variable2, variable3, etc...)

[NBVC]

Maybe...

=IF(OR(F2=0,F2="ERROR"),0,IF(OR(A2<A1,D2<D1)),(F2/G2),0)).

[Maddyv]

=IF(OR(F2=0,F2="ERROR"),0,IF(OR(A2<A1,D2<D1)),(F2/G2),0))


What am I doing wrong? It's not working for me

[NBVC]

Sorry, this time my fault.. too many brackets closing

=IF(OR(F2=0,F2="ERROR"),0,IF(OR(A2<A1,D2<D1),(F2/G2),0))

[Maddyv]

'=IF(OR(F2=0,F2="ERROR"),0,IF(OR(A2<A1,D2<D1),(F2/G2),0))


It's coming back as '0', rather than a '2'.....now what???? :-(

[ChemistB]

This equation should bring back a zero if any of the following condtions are true;
1. F2 = Error
2. F2 = 0
3. A2 >= A1 And D2>=D1

So you are saying that none of these conditions are met but it's still giving 0?

[zbor]

This:

=IF(AND(ISNUMBER(F2);A2>A1;D2>D1);F2/G2;0)

[Maddyv]

ChemistB:

1) F2=Error
2) F2<= 0

Then I want "0" return. But, if F2 is not a "0" but A2<A1 and D2<D1, could be just A2<A1 or just D2<D1 or neither, then I want F2/G2. In this case, the answer I'm hoping for is "2" which is 14/7.

[zbor]

ChemistB:

1) F2=Error
2) F2<= 0

Then I want "0" return. But, if F2 is not a "0" but A2<A1 and D2<D1, could be just A2<A1 or just D2<D1 or neither, then I want F2/G2. In this case, the answer I'm hoping for is "2" which is 14/7.

You sounds inconsistent to me: you said:

if F2 is not a "0" but A2<A1 and D2<D1

and on another place:


A2<A1 or just D2<D1

Can you write in table several examples and state for wich it's working for wich it don't.

Write different cases (A2<A1, A2>A1, A2=A1.. same for D1, D2...)

[Maddyv]

It's actually and/or....as in BOTH could be < than the cell above or just one of them or neither of them? Does that make sense....if not, I'll attempt to rewrite as you requested...

[zbor]

There's no AND/OR. If that's case only OR is enough because OR contains AND.

[Maddyv]

=IF(OR(F2=0,F2="ERROR"),0,IF(OR(A2<A1,D2<D1),(F2/G2),0))

So how can I use the above formula with a return of 2, rather than 0?