Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Lesson learned: Do not trust Google Sheets function Google Sheets
  • Show developer tab Excel User tips
  • Hello world! Uncategorized
  • State Abbr with Index+Match+Validation Data Validation
  • VALUE() of LEFT() Formulas - combined functions
  • Excel keeps converting all cells to “Date” (or Time) Excel User tips
  • Unix DateTime Number Basic Math
  • Why I ran from =INDIRECT() function Formulas - combined functions

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

  • Sort list dynamically (functions) COLUMN
  • IF with AND and IF with OR AND
  • Convert 2-column into wide (column-row) table Formulas - combined functions
  • Always get 1st name (or last) Formulas - combined functions
  • Search across sheets in function ADDRESS
  • 0% interest promotion Basic Math

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
  • VLookup Lookup and References
  • Get column name (columnname as A,B,C, etc) as input inside cell ADDRESS
  • IFS (and IFNA) to avoid nested IFs Formulas - combined functions
  • WorksheetName and WorksheetsNo UDFs Lookup and References
  • Dynamic selection list ActiveX controls
  • Change Calculator – calculate change in multiple bills/coins Formulas - combined functions
  • Expenses calendar, FaCal Basic Math
  • Zipcode-State search Formulas - combined functions

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme