Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Edit directly in cell Excel User tips
  • Hyperlink usage and HyperlinkOf UDF CELL
  • CamelCase to Camel Case CHAR
  • VALUE() of LEFT() Formulas - combined functions
  • MATCH fumction, just a simple search Lookup and References
  • Comments versus Notes Excel User tips
  • VLookup Lookup and References
  • Week number to Sunday date – Weeknum reverse DATE

Category: Standard functions

Standard functions that comes with Excel, plain single functions

CHOOSE – tree of decisions

Posted on February 20, 2020 By ANmar
CHOOSE – tree of decisions

If you are like me, then you must have needed to use CHOOSE functionThis is basically like “SELECT CASE” statement, but more limited So, in few words, you can derive the flow of formulas to go to function1, function2, function3, or function4 based on an integer.More like a nested IF, it can actually replaces a…

Read More “CHOOSE – tree of decisions” »

CHOOSE, Formulas - combined functions, IF

Count Unique

Posted on August 9, 2019 By ANmar
Count Unique

A question by a colleague on how to count number of unique items in a column made me realize, I don’t have that here.

So here it is …

COUNTIF, Formulas - combined functions, IF, Standard functions, Statistical, Uncategorized

DayName

Posted on January 25, 2019 By ANmar
DayName

Simplest way to get name of day as cell output from a date.

Because you can custom format a cell with date to show only that day name

This is not that.

Read More “DayName” »

Date and Time, Standard functions, TEXT, Texts and Strings

Fixed length ID

Posted on January 22, 2019 By ANmar
Fixed length ID

I needed few months back to make a fixed-length ID iut if none-fixed-length numbers.

SO I used the function REPT with RIGHT to force all numbers to be converted into fixed-length ID (mainly having leading zeros)

And here is the formula

Read More “Fixed length ID” »

Formulas - combined functions, REPT, RIGHT, Texts and Strings

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

Expenses calendar, FaCal

Posted on December 7, 2018 By ANmar
Expenses calendar, FaCal

Expenses calendar, to show when in a month you need to pay what bill An easy formula-only smart sheet to allow you get hold on your bills Refreshes every time you open, to show current month and shows bills   Download FaCal Excel Online

Basic Math, Conditional Formatting, DATE, Date and Time, MONTH, NETWORKDAYS, Non-functions, Standard functions, TODAY, WEEKDAY, YEAR

Custom fiscal year calendar (CFlex)

Posted on December 5, 2018 By ANmar

Fully customized Yearly Calendar to show certain dates with certain format using conditional formatting, like mark 8th business day each month with certain color, 1st workday after 15th of each month, etc.
See the sheet “Data” for details and table of specific dates and rules. Contact me for more detail

Read More “Custom fiscal year calendar (CFlex)” »

Basic Math, Conditional Formatting, Data Validation, DATE, Date and Time, MONTH, Non-functions, Standard functions, TODAY, WEEKDAY, YEAR

Compare2, a tool to compare two sheets using formulas

Posted on December 5, 2018 By ANmar
Compare2, a tool to compare two sheets using formulas

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 these two files are open, then sheet will be updated with comparison results, showing that every cell is checking for its equivalent addresses from both…

Read More “Compare2, a tool to compare two sheets using formulas” »

Conditional Formatting, Formulas - combined functions, IF, Logical, Standard functions

BMI Calculator

Posted on December 5, 2018 By ANmar
BMI Calculator

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

Read More “BMI Calculator” »

Basic Math, IF

Posts pagination

Previous 1 2 3 4 … 8 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
  • Worksheet name, dynamically using formula CELL
  • CountIf limitation COUNTIF
  • Show developer tab Excel User tips
  • Week number to Sunday date – Weeknum reverse DATE
  • Calculate hours between two cells ABS
  • IF with AND and IF with OR AND
  • Searching table in 2 dimensions. Formulas - combined functions
  • CamelCase to Camel Case CHAR

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme