Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • State Abbr with Index+Match+Validation Data Validation
  • Count how many times letter found Formulas - combined functions
  • Why I ran from =INDIRECT() function Formulas - combined functions
  • Get 3rd Wednesday of month Basic Math
  • Unix DateTime Number Basic Math
  • 6174 Kaprekar’s constant Basic Math
  • Spreadsheet Compare application Excel User tips
  • Excel keeps converting all cells to “Date” (or Time) Excel User tips

Tally chart in functions

Posted on January 26, 2012 By ANmar No Comments on Tally chart in functions

Using a single function can make a graphical view to your number

Function is REPT along with IF and INT to show that number in graphical view, formula used here is:

=IF(B4<5,REPT("|",B4),REPT(REPT("|",5)&"-",INT(B4/5))&REPT("|",B4-INT(B4/5)*5))

Formulas - combined functions, IF, INT, Logical, Math and Trig, REPT, Standard functions, Texts and Strings

Post navigation

Previous Post: CamelCase to Camel Case
Next Post: Excel Dynamic Drop-Downs that grow with you

Related Posts

  • State Abbr with Index+Match+Validation Data Validation
  • The Excel “&” bug Excel User tips
  • Middle name + 1st name Basic Math
  • Custom fiscal year calendar (CFlex) Basic Math
  • Excel @ before function names in formulas Excel User tips
  • Week number to Sunday date – Weeknum reverse DATE

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

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
  • CHOOSE – tree of decisions CHOOSE
  • Sort list dynamically (functions) COLUMN
  • Progress bar in pure functions CHAR
  • Shades of gray Graphics
  • Blank (isempty) VS “” (null string) Excel User tips
  • Rotate table using 1 formula ADDRESS
  • 6174 Kaprekar’s constant Basic Math
  • Skills Grid Conditional Formatting

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme