Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Week number to Month number DATE
  • Sum of divide – Array formula Array formula
  • CONVERT function CONVERT
  • Paste Special Percentage Excel User tips
  • Cell formats 0.0\% and 0.0%;(0.0%) Format Cells
  • BMI Calculator Basic Math
  • Comments versus Notes Excel User tips
  • Convert cell into textbox Excel User tips

Category: Basic Math

Middle name + 1st name

Posted on February 3, 2024 By ANmar
Middle name + 1st name

Get the initial (middle name) from a triple name in a cell.
C4 The cell contains the triple name separated with spaces.
=LEFT(C4,1) & "." & MID(C4, SEARCH(" ", C4, 1) + 1, 1) & "." & MID(C4, SEARCH(" ", C4, SEARCH(" ", C4, 1) + 1) + 1, 1) & "."

Read More “Middle name + 1st name” »

Basic Math, Formulas - combined functions, LEFT, MID, SEARCH, Standard functions, Texts and Strings

Walking Columns

Posted on January 14, 2023 By ANmar
Walking Columns

An easy way to scroll through set of data in a graphic way without graphs.

A-pure-formula xlsx workbook. These were done using formulas, conditional formatting, and ActiveX control.

Read More “Walking Columns” »

ActiveX controls, Basic Math, COLUMN, Conditional Formatting, Formulas - combined functions, IF, INT, Logical, Lookup and References, Math and Trig, Non-functions, OFFSET, ROW, Standard functions

Unix DateTime Number

Posted on January 6, 2023 By ANmar
Unix DateTime Number

Convert Date/time number from regular number to Unix DateTime Number.

Read More “Unix DateTime Number” »

Basic Math, DATE, Date and Time, Standard functions

Get 3rd Wednesday of month

Posted on November 15, 2022 By ANmar
Get 3rd Wednesday of month

This was an interesting request.

Needing to get the date of 3rd Wednesday for a given month, automatically, using pure Excel functions.

So, sharing here on what is the formula and how to get there.

Read More “Get 3rd Wednesday of month” »

Basic Math, CHOOSE, DATE, Date and Time, Formulas - combined functions, Lookup and References, MONTH, Standard functions, WEEKDAY, YEAR

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

6174 Kaprekar’s constant

Posted on September 2, 2022 By ANmar
6174 Kaprekar’s constant

This is the spreadsheet to prove this constant. When all roads lead to Kaprekar

Just enter any 4 digits number in D3 and watch roads walk you 6174

Read More “6174 Kaprekar’s constant” »

Basic Math, Formulas - combined functions, Standard functions, TEXT, Texts and Strings, VALUE

0% interest promotion

Posted on July 11, 2022 By ANmar
0% interest promotion

The past few months, I established a formula to help me determine if certain credit card promotion makes sense or not.

This helped me a lot in consolidating my debts (credit card as well others) into interest-free payments. Benefiting from banks and cards promotions. The key part is to determine how much monthly I will commit to pay in order to keep it actually 0%.

So here is the formula.

Read More “0% interest promotion” »

Basic Math, Formulas - combined functions, INT, Math and Trig, Standard functions

Schedule column

Posted on July 6, 2022 By ANmar
Schedule column

Create list of dates excluding weekends and holidays.
Basically create list of workdays in a certain year, you may fill in to get more.

List of holidays is defined in another column, formula already excludes Saturdays and Sundays.

Read More “Schedule column” »

Basic Math, COUNTIF, Date and Time, Formulas - combined functions, IF, Logical, Standard functions, Statistical, WEEKDAY

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

Looplist – Repeating months using formulas

Posted on December 11, 2018 By ANmar
Looplist – Repeating months using formulas

Using formulas to repeat list, I call it LoopList

Used to list Months for several years, in away that with 1 formula, it will loop through all months, then jumps into next year and loop through its months again, and so on

Read More “Looplist – Repeating months using formulas” »

Basic Math, Date and Time, Formulas - combined functions, MATCH, MONTH, OFFSET, ROW, YEAR

Scorring, saving multiple outputs in 1 number

Posted on December 10, 2018 By ANmar
Scorring, saving multiple outputs in 1 number

I have seen this practice before several locations

Returning multiple outputs in 1 single number.

for example

Read More “Scorring, saving multiple outputs in 1 number” »

Basic Math, Conditional Formatting, Formulas - combined functions, Logical, Non-functions, Standard functions

Posts pagination

1 2 Next

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 current (Active) workbook name CELL
  • Workdays – Across months DATE
  • Highlight dates dynamically AND
  • Comments versus Notes Excel User tips
  • Calculate hours between two cells ABS
  • SimpleANBox Basic Math
  • Excel ad from early 90s Non-functions
  • CHOOSE – tree of decisions CHOOSE

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme