This course lesson is all about the usefulness of TRUE/ FALSE checks in Excel.
Did you know that you can extract the simple logic test from an If formula (= the first box in the “Shift” “F3” insert formula dialog) and that it stands alone?
You can happily compare two results in Excel and get a TRUE or FALSE result delivered into your spreadsheet. This is a small tip for creating super-quick checks in a model – making sure an output matches expectation.
But with this lesson you may start appreciating that you can happily multiply a number by one of those logic tests.
All this means that we’ve got a shortcut on the standard If function – often you’ll see advanced modellers using those and multipling a number by a logic test as a shortcut.
If this idea is new to you, after this course lesson you may end up taking a pledge never to use a full If function again!
Start the Excel course
Here we’ve got a free online course for you that covers the most useful Excel formulas.