excel - Can You Embed an AND Statement Within an OR Statement? -

OK, so I have an idea, but I'm not sure there is a way to accomplish this. Starting with this equation:

= If (or (AREAE FARMA (SUM (COUNTIF (B7: O7, {"I", "A", "X", "R" "K", "E", "AL", "FFSL", "ADM *"}))) = 10), "80 hours", "error")

IF statement, if it's all possible, for example, the above equation looks at all possible 8 hours shift. If there are 10 of them then the employee has time to work 80 hours. I have to check the combination of next 4 hours shift and 5 eight hours shifts. Then I have to continue checking the other possible combinations that the employee will get for 80 hours.

I know that this equation below does not work, but this is what I am trying to do.

= If (or (ARRAYFORMULA (SIM (COUNTIF (B7: O7, {"I", "A", "X", "R", "K", "E", " AL "," FFSL "" ADM * "}) = 10, (ARRAYFORMULA (sum (COUNTIF (B7: O7, {" R-10 "," I-10 "," X10 "," A -10 "}) = 4, and (ARRAYFORMULA (sum (COUNTIF (B7: O7, {" I "," A "," X "," R "," K "," E "," Al "," FFSL "," ADM * "})) = 5)," 80 hours "," error ")

Basically I am trying to embed another statement within the original and description I'm saying something like this:

If 1 or (2 and 3) or (3 and 4), etc ...

shouldn 'can it be that way?

= Or (ARRAYFORMULA (SUM (COUNTIF (B7: O7, {"I", "A", "X", "R", "K", "E", "AL", "FFSL", "ADM *"} ) = 10, and (AREEFermula (SM (COUNTIF (B7: O7, {"R-10", "I-10", "A-10", "A-10"}))) = 4 , AERAFFAMULA (SM (COUNTIF (B7: O7, "I", "A", "X", "R", "K", "E", "AL", "FFSL", "ADM *"} ))))) = 5)), "80 hours", "error")