Power Query does not have an IFERROR function. It does however have another function that performs the same type of calculation.
Monthly Archives: November 2020
Prefix Numbers Conditionally in Excel
Conditional Format to the rescue
Let’s say we need to put a prefix in front of a number to identify the period being used. Whether that be year, month or week.
Validate a whole number in Excel
Very INTeresting
If you need to confirm a number is a whole number you can use a function with a short name.
A beginning is the time for taking the most delicate care that the balances are correct.
Frank Herbert (1920-1986)
Automating bullet points in Excel
Great for text boxes
Some people like to use bullet points in text boxes. Here is a simple technique to insert bullet points based on a list of entries in an Excel sheet.