Nested IFs in Excel
How to write an IF statement in Excel, and nest IF statements to test for multiple conditions. Key tips and rules about IFs and nested IFs in Excel.
Excel Formula
EVALUATE FORMULA in Excel to find errors
How to find errors in a complex formula, step by step, using Excel’s EVALUATE FORMULA function. Where to find the command, method, worked example, and related topics.
Dynamic array of latest values from a table in Excel
In this detailed worked example, we show step by step how to retrieve a dynamic array of values, using a range of Excel’s functions including OFFSET, INDEX MATCH, INDIRECT, and ADDRESS.
Excel formula not calculating automatically
How to fix Excel when formulas are not automatically calculating and flash fill doesn’t fill the formula down the column.
Calculate a RUNNING TOTAL in Excel
Sum the current value and all those that precede it in a column. This topic also shows how to fill cells down a column.
COMPARE more than two values in Excel
To compare more than 2 cells to check if they are equal.
=(A1=B1)*AND(B1=C1)