Essentials · Formulas

Conditional Logic

4 lessons and 56 marked steps, with a workbook to open in Excel alongside. Your first two lessons on LogicExcel are free with a free account; after that every lesson opens with the All-Access Pass.

1. 1. IF: one decisionAll-Access Pass

   Write an IF that returns one of two results, choose what the false branch should say, and recognise the two ways an IF quietly returns the wrong thing.

   14 marked steps

2. 2. Nested IF and IFSAll-Access Pass

   Band a value into three or more categories, choose IFS over a nested tower, and order the tests so the bands do what they say.

   14 marked steps

3. 3. AND, OR, NOTAll-Access Pass

   Combine several conditions in one test, choose between AND and OR deliberately, and build a compound condition from the inside out.

   14 marked steps

4. 4. Error trapping with IFERRORAll-Access Pass

   Trap the error you expect without hiding the ones you do not, and explain why a trapped error that returns zero is worse than a visible one.

   14 marked steps

Finished Formulas? Sit the Formulas exam for its certificate.