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 Exercise
You should attempt the IF and Lookups - Exercises a, b, c, d and e from the Spreadsheet Exercises listed in the Topic Menu below.