IF AND OR in one formula

The use of IF, AND and OR in one formula can at times be rather confusing when one isn't used to how to put these elements together so that they make sense.

This file has several examples with explanations. I have intentionally left out the use of ARRAY CONSTANTS to keep it simple for those just starting out.

Helpful for folks warming up to the various nuances of IF, OR & AND.

Although, you get rid of the "" around the TRUE & FALSE. Furthermore, you get rid of the IF statement altogether. Hence in your first example...

=AND(B4<=5,C4>=10,OR(A4="A",A4="B",A4="C"))

would still give TRUE/FALSE

You are correct about the TRUE and FALSE not needing the "" around them. I did a search and replace to put TRUE and FALSE in the formulae because I had other terms in there that did require the "". As for the formula =AND(B4<=5,C4>=10,OR(A4="A",A4="B",A4="C")) I did not use it because I was specifically trying to demonstrate how to use the construction in IF formulae.