Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Limited Ceiling Basic Math
  • State Abbr with Index+Match+Validation Data Validation
  • Cuts string of list of items Formulas - combined functions
  • Excel Functions = XL f(x)s XLfxs
  • Excel ad from early 90s Non-functions
  • Always get 1st name (or last) Formulas - combined functions
  • OFFSET+MATCH Formulas - combined functions
  • Return 12 values in one number AND

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

  • Convert 2-column into wide (column-row) table Formulas - combined functions
  • Change Calculator – calculate change in multiple bills/coins Formulas - combined functions
  • Walking Columns ActiveX controls
  • Dynamic selection list ActiveX controls
  • 0% interest promotion Basic Math
  • Validation based on another Validation COUNTA

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
  • Show developer tab Excel User tips
  • UDF – Convert Number into text (English and Arabic) User-Defined f(x)s = UDF
  • Sorting with functions only CHOOSE
  • VLookup Lookup and References
  • Convert 2-column into wide (column-row) table Formulas - combined functions
  • Multiple lines in cell using functions CHAR
  • Text-to-Columns, dynamically using formulas IFERROR
  • Excel sessions – 2013 VS 2010 Excel User tips

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme