either/or in a formula

[Connie]

I have a very long formula, which is:
=IF(D11=A78,IF(E13=A80,O75,IF(D11=A78,IF(E13=A81,O78,IF
(D11=A76:A77,IF(E13=A80:A81,O81,""))))))

It's only the last part that's not working:
IF(D11=A76:A77,IF(E13=A80:A81,O81,""))))))

I get the FALSE answer instead of a number or nothing at
all. I have a feeling it's because of A76:A77 and A80:A81
in the formula because it's text that's in those cells,
just as it's text in A78. Really, what I want to say is
this:

If D11 equals either A76 or A77, if E13 equals either A80
or A81, then return O81, otherwise put nothing.

How do I put in the either/or bit?

Connie

 

[Dave R.]

Try something like

IF(or(D11=A76,D11=A77),IF(or(E13=A80,E13=A81),O81,""))))))

 

[Connie]

Thank you! That works, but I was still getting the FALSE
response so I dissected the formula, doing it in parts and
found that yours worked, but it's the first two sections
that are giving the FALSE answer.

=IF(D11=A78,IF(E13=A80,O75)) gives FALSE instead of a
number. What I'm trying to say here is this:

If D11=A78 and if E13=A80 then give O75.

What about that one?

Connie

 

[Dave R.]

=IF(AND(D11=A78,E13=A80),O75,"")

Thank you! That works, but I was still getting the FALSE
response so I dissected the formula, doing it in parts and
found that yours worked, but it's the first two sections
that are giving the FALSE answer.

=IF(D11=A78,IF(E13=A80,O75)) gives FALSE instead of a
number. What I'm trying to say here is this:

If D11=A78 and if E13=A80 then give O75.

What about that one?

Connie

 

[Connie]

Guess I've a few things to learn about nesting functions!
Thanks again!

Connie