Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Unix DateTime Number Basic Math
  • Looplist – Repeating months using formulas Basic Math
  • Get monthly total from table with dates DATE
  • UDF – Convert Number into text (English and Arabic) User-Defined f(x)s = UDF
  • Shapes with dynamic output Excel User tips
  • Cuts string of list of items Formulas - combined functions
  • Middle name + 1st name Basic Math
  • Sorting with functions only CHOOSE

Category: IFERROR

Repeated Offset

Posted on September 19, 2022 By ANmar
Repeated Offset

I needed to have an offset of columns to be repeated every 12 months.

This is part of a project, we needed to calculate the coefficient of sales prediction based on the month number, we do have coefficient saved in another table that repeated every year (12 months).

Read More “Repeated Offset” »

Basic Math, COLUMN, Formulas - combined functions, IFERROR, INT, Logical, Lookup and References, Math and Trig, OFFSET, Standard functions

VALUE() of LEFT()

Posted on July 7, 2022 By ANmar
VALUE() of LEFT()

I have been in a lot of situation needing to convert a number came out from a string into actual numbers. Sometimes N() worked, sometimes not, others VALUE() worked, but I did not see a function-does-all solution.

Read More “VALUE() of LEFT()” »

Formulas - combined functions, IF, IFERROR, Information, LEFT, Logical, N, Standard functions, Texts and Strings, VALUE

SimpleANBox

Posted on January 21, 2019 By ANmar
SimpleANBox

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 found myself needing to open a lot of these boxes, to track accounts, or loans, or virtual business partnerships between multiple partnerrs. And this is the core to it.

Read More “SimpleANBox” »

Basic Math, DATE, Date and Time, Formulas - combined functions, IF, IFERROR, Logical, Math and Trig, SUM, TODAY, WEEKDAY, Worksheet

Skills Grid

Posted on October 26, 2018 By ANmar
Skills Grid

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

Read More “Skills Grid” »

Conditional Formatting, Data Validation, Formulas - combined functions, IF, IFERROR, Logical, Lookup and References, Names, Non-functions, OFFSET, Standard functions, VLOOKUP, Worksheet

Text-to-Columns, dynamically using formulas

Posted on April 3, 2018 By ANmar
Text-to-Columns, dynamically using formulas

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 that row) into 1 text block.

And then, because of that, I need to extract that back, into table

Read More “Text-to-Columns, dynamically using formulas” »

IFERROR, Len, MID, SEARCH

New function IFERROR, finally

Posted on December 24, 2017 By ANmar
New function IFERROR, finally

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 guy, IFERROR instead, which will show the result if it did not generate error, otherwise will show something else if it resulted an error.

Read More “New function IFERROR, finally” »

IFERROR, VLOOKUP

Recent Posts

  • Stale values (Scratched functions)
  • Middle name + 1st name
  • LastSunday, LastSaturday
  • Paste Special Percentage
  • Jan8 date format

Archives

Categories

  • Array formula (1)
  • Formulas – combined functions (58)
  • Google Sheets (2)
  • Non-functions (36)
    • ActiveX controls (2)
    • Conditional Formatting (7)
    • Data Validation (7)
    • Excel User tips (19)
    • Format Cells (6)
    • Graphics (4)
    • Names (3)
  • Standard functions (82)
    • Basic Math (18)
    • Date and Time (16)
      • DATE (9)
      • Hour (1)
      • MONTH (7)
      • NETWORKDAYS (2)
      • TODAY (7)
      • WEEKDAY (8)
      • WEEKNUM (1)
      • YEAR (8)
    • Engineering (1)
      • CONVERT (1)
    • Information (6)
      • CELL (4)
      • ISERROR (1)
      • N (1)
    • Logical (30)
      • AND (5)
      • IF (24)
      • IFERROR (6)
      • IFNA (1)
      • IFS (1)
      • ISERROR (1)
      • OR (2)
    • Lookup and References (36)
      • ADDRESS (4)
      • CHOOSE (3)
      • COLUMN (7)
      • FORMULATEXT (1)
      • HLOOKUP (1)
      • HYPERLINK (2)
      • INDEX (5)
      • INDIRECT (6)
      • MATCH (12)
      • OFFSET (15)
      • ROW (11)
      • VLOOKUP (5)
    • Math and Trig (24)
      • ABS (1)
      • CEILING (1)
      • COUNT (1)
      • COUNTA (4)
      • INT (9)
      • LARGE (2)
      • MAX (1)
      • Min (2)
      • SMALL (3)
      • SUM (3)
      • SUMIF (1)
      • SUMIFS (2)
      • SUMPRODUCT (1)
    • Statistical (5)
      • COUNTIF (4)
      • COUNTIFS (1)
    • Texts and Strings (24)
      • CHAR (5)
      • CONCATINATE (1)
      • FIND (1)
      • LEFT (8)
      • Len (4)
      • MID (9)
      • REPT (3)
      • RIGHT (2)
      • SEARCH (9)
      • STRING (1)
      • SUBSTITUTE (2)
      • TEXT (4)
      • TRIM (2)
      • VALUE (2)
  • Uncategorized (2)
  • User-Defined f(x)s = UDF (3)
    • HyperlinkOf (1)
  • Worksheet (16)
  • XLfxs (2)

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
  • Extract Address into table Formulas - combined functions
  • Count how many times letter found Formulas - combined functions
  • Repeated Offset Basic Math
  • Compare2, a tool to compare two sheets using formulas Conditional Formatting
  • Shades of gray Graphics
  • Unix DateTime Number Basic Math
  • New function IFERROR, finally IFERROR
  • iframe in Excel (XLiFrame) ADDRESS

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme