Logical – 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 …

Scorring, saving multiple outputs in 1 number

ANmar Basic Math / Conditional Formatting / Formulas - combined functions / Logical / Non-functions / Standard functions December 10, 2018 January 21, 2019

I have seen this practice before several locations Returning multiple outputs in 1 single number. for example

Compare2, a tool to compare two sheets using formulas

ANmar Conditional Formatting / Formulas - combined functions / IF / Logical / Standard functions December 5, 2018 December 6, 2018

Tool will compare between two sheets using formula/functions method. Once you type in full folder locations (for both files), file names and sheets names in file1 and file2. Make sure …

BMI Calculator

ANmar Basic Math / IF BMI / Calculator / Convert December 5, 2018 December 5, 2018

A simple calculator, how come we do not have one like this?

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 …