Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • 0% interest promotion Basic Math
  • Cell formats 0.0\% and 0.0%;(0.0%) Format Cells
  • CHOOSE – tree of decisions CHOOSE
  • Edit directly in cell Excel User tips
  • IFS (and IFNA) to avoid nested IFs Formulas - combined functions
  • Workdays – Across months DATE
  • Unix DateTime Number Basic Math
  • Convert 2-column into wide (column-row) table Formulas - combined functions

Scorring, saving multiple outputs in 1 number

Posted on December 10, 2018 By ANmar

I have seen this practice before several locations

Returning multiple outputs in 1 single number.

for example

If you have list of items:

Red

Blue

Black

Gray

Green

Pink

Yellow

Orange

And then you have a function that need to return, Red yellow, or black orange, or blue gray green.

How can you do that in 1 return? or 1 number?

Answer is as I like to call “Scorring”, which by giving numeric value to each of these items, these values need to be unique so we can calculate them again from the single return number.

Best that I found were these numbers.

1: Red

2: Blue

4: Black

8: Gray

16: Green

32: Pink

64: Yellow

128: Orange

Look familiar? I bet …

Means if we need to return Red blue, our number should be 3

Red black, 5

Red only, 1

if blue black gray, then return 14

red gray pink, it is 31

And so on

This Excel file has formulas needed to break a large number (up tp 1m) into its small parts, again I call it here scorring, not sure what is the official practice name is.

Download
Online Excel version
Basic Math, Conditional Formatting, Formulas - combined functions, Logical, Non-functions, Standard functions

Post navigation

Previous Post: Expenses calendar, FaCal
Next Post: Looplist – Repeating months using formulas

Related Posts

  • Excel ad from early 90s Non-functions
  • Compare2, a tool to compare two sheets using formulas Conditional Formatting
  • Looplist – Repeating months using formulas Basic Math
  • Middle name + 1st name Basic Math
  • Fixed length ID Formulas - combined functions
  • iframe in Excel (XLiFrame) ADDRESS

Recent Posts

  • Calculate above and below me
  • Stale values (Scratched functions)
  • Middle name + 1st name
  • LastSunday, LastSaturday
  • Paste Special Percentage

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 (83)
    • 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 (31)
      • AND (5)
      • IF (25)
      • IFERROR (7)
      • 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 (6)
      • Average (1)
      • 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
  • Blank (isempty) VS “” (null string) Excel User tips
  • Worksheet name, dynamically using formula CELL
  • VALUE() of LEFT() Formulas - combined functions
  • Excel ad from early 90s Non-functions
  • Excel keeps converting all cells to “Date” (or Time) Excel User tips
  • WorksheetName and WorksheetsNo UDFs Lookup and References
  • Custom fiscal year calendar (CFlex) Basic Math
  • When Excel tells you to go get some life Excel User tips

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme