Power Query IF and IF AND statements
How to write an IF AND ELSE statement in Power Query and Power BI, showing syntax and examples.
IF
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 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.
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.
Remove BLANK CELLS in chart data table in Excel
How to remove blank cells from a set of data so that a plotted line is continuous. Example shows blank cells being replaced by ‘N/A’ values using an IF statement.
Excel IF function
To test IF a value matches a condition, and return one result if TRUE, and another if FALSE.