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 Function
Excel IFERROR then blank; IFERROR VLOOKUP
Excel’s IFERROR function traps errors that could be returned from a formula or calculation, and gives you control over what is returned instead of an error message. Examples with syntax showing IFERROR then blank, IFERROR with VLOOKUP, IFERROR then perform another function.
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.
Sum values if cells contain specific text in Excel
How to search a range of cells for specific text, and then sum another range of cells based on the search results. Worked examples using a combination of ISNUMBER, SEARCH, SUMPRODUCT, SUMIF.
Conditional formatting: highlight dates in current week
How to apply conditional formatting based on dates that fall in the current week. Syntax and example using a Gantt chart and weekly tasks.
VLOOKUP MATCH two-way lookup in Excel
How to use Excel’s VLOOKUP MATCH functions to find values based on row and column lookups. The MATCH function offers several ways to create dynamic lookups, which can be easily copied across a range of cells in a worksheet.
INDEX and MATCH in Excel
How to combine Excel’s INDEX and MATCH functions to look up values. Syntax, examples and explanations of how to use INDEX and INDEX MATCH in Excel.
Add time using Excel’s TIME() function
How to use Excel’s TIME function to add time to time, with a worked example to create a series of appointments.
FORMULATEXT function in Excel – display formulas
It can be useful to inspect a cell’s formula visually without having to click in it to display the formula in the formula bar. Excel’s FORMULATEXT function enables you to see the formula in another cell.
CONCATENATE in Excel
To join text and/or numbers together using Excel’s CONCATENATE / CONCAT function. An example is shown how to generate a a set of SUM(CASE WHEN) SQL statements.