IFERROR – XLf(x)s = Excel Functions

SimpleANBox

ANmar Basic Math / DATE / Date and Time / Formulas - combined functions / IF / IFERROR / Logical / Math and Trig / SUM / TODAY / WEEKDAY / Worksheet DATE / IF / IFERROR / SUM / TODAY / WEEKDAY January 21, 2019 January 21, 2019

This is a financial box, a saving account, a credit, a loan, or any other financial amount that has input and output. During my time with technology (since 1997) I …

Skills Grid

ANmar Conditional Formatting / Data Validation / Formulas - combined functions / IF / IFERROR / Logical / Lookup and References / Names / Non-functions / OFFSET / Standard functions / VLOOKUP / Worksheet October 26, 2018 December 5, 2018

A small Excel file to show how we can create a chart-like Excel sheet Used in my Resume to show different skill sets and the level of expertise in each

Text-to-Columns, dynamically using formulas

ANmar IFERROR / Len / MID / SEARCH April 3, 2018 April 3, 2018

I often use the technique of concatenating columns into 1 cell with separators. Something like the CSV, 1 line that has all values for a single row (all columns for …

New function IFERROR, finally

ANmar IFERROR / VLOOKUP December 24, 2017 December 26, 2017

We have already gotten used to use VLOOKUP, MATCH and other functions that generates errors inside an IF But, we do not need that anymore We can use the new …