I don't know why T. Valko thinks D24 can never be greater than C24, nor D26
than C26; he may be seeing something I'm missing. And I think he's
misreading your return. The problem I see is in the way you've combined the
two IF formulae; you seem to have them one after the other instead of one
inside the other. I agree with his suggestion, though: Can you explain in
words what you're trying to accomplish by combining the two IFs? Either one
of them alone looks like to me.

And by the way, WHAT error do you get? It makes a difference.

IF(
(
AND(
OR(Cust!B5="X",Cust!B5="Y"),
Cust!D24Cust!C24),
Cust!C24,Cust!D24),
IF(
AND(
OR(Cust!B5="X",Cust!B5="Y"),
Cust!D26Cust!C26),
Cust!C26,Cust!D26))

--- "CJOHNSO92" wrote:
Can I combine 2 IF/AND/OR statements? Below are the two formulas -
individually, they each calculate properly.

IF(AND(OR(Cust!B5="X",Cust!B5="Y"),Cust!D24Cust!C 24),Cust!C24,Cust!D24)

IF(AND(OR(Cust!B5="X",Cust!B5="Y"),Cust!D26Cust!C 26),Cust!C26,Cust!D26)

When combined, I get an error:
IF((AND(OR(Cust!B5="X",Cust!B5="Y"),Cust!D24Cust! C24),Cust!C24,Cust!D24),IF(AND(OR(Cust!B5="X",Cust !B5="Y"),Cust!D26Cust!C26),Cust!C26,Cust!D26))

"CJOHNSO92" wrote:

Can I combine 2 IF/AND/OR statements? Below are the two formulas -
individually, they each calculate properly.

IF(AND(OR(Cust!B5="X",Cust!B5="Y"),Cust!D24Cust!C 24),Cust!C24,Cust!D24)

IF(AND(OR(Cust!B5="X",Cust!B5="Y"),Cust!D26Cust!C 26),Cust!C26,Cust!D26)

When combined, I get an error:
IF((AND(OR(Cust!B5="X",Cust!B5="Y"),Cust!D24Cust! C24),Cust!C24,Cust!D24),IF(AND(OR(Cust!B5="X",Cust !B5="Y"),Cust!D26Cust!C26),Cust!C26,Cust!D26))