Compound IF Statements

Often it is necessary to combine statements.

If an animal is a cat and animal has stripes then it is a tiger.

Statements can be combined with the following operators

AND
OR
NOT

These are known as BOOLEAN operators.
(George Boole was an Irish Cleric who specialised in logic - go figure!)

Example: Place the following IF function in Cell E3

=If (and(A1=50,B7=10),5000,0)

Here cell A1 must = 50 AND B7 must =10 before E3 shows 5000.

---

Practice Exercises

You should attempt exercises 9.1, 9.2, 9.3, 9.4 and 9.5

---