Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Always get 1st name (or last) Formulas - combined functions
  • Excel Functions = XL f(x)s XLfxs
  • 0% interest promotion Basic Math
  • Stale values (Scratched functions) Excel User tips
  • Multiple-Validations (connected to each other) Data Validation
  • Zipcode-State search Formulas - combined functions
  • SimpleANBox Basic Math
  • Sorting with functions only CHOOSE

CHOOSE – tree of decisions

Posted on February 20, 2020 By ANmar

If you are like me, then you must have needed to use CHOOSE function
This 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 nested IF if you can, use it, it is faster, and most important, easier to maintain.

If Index_Num = 1, the first Value (Value1) will be executed
If Index_num = 2, the Value2 will be executed
If 3, then Value3
And so on …

CHOOSE, Formulas - combined functions, IF Tags:CHOOSE, identifier, IF, Nested

Post navigation

Previous Post: Blank (isempty) VS “” (null string)
Next Post: CountIf limitation

Related Posts

  • Skills Grid Conditional Formatting
  • Cuts string of list of items Formulas - combined functions
  • Repeated Offset Basic Math
  • Change Calculator – calculate change in multiple bills/coins Formulas - combined functions
  • Count cells with condition – multiple conditions COUNTIFS
  • Count how many times letter found Formulas - combined functions

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
  • Change Calculator – calculate change in multiple bills/coins Formulas - combined functions
  • Shapes with dynamic output Excel User tips
  • Get monthly total from table with dates DATE
  • Compare2, a tool to compare two sheets using formulas Conditional Formatting
  • MATCH fumction, just a simple search Lookup and References
  • State Abbr with Index+Match+Validation Data Validation
  • Show developer tab Excel User tips
  • Extract Address into table Formulas - combined functions

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme