Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Compare2, a tool to compare two sheets using formulas Conditional Formatting
  • Text-to-Columns, dynamically using formulas IFERROR
  • Excel Functions = XL f(x)s XLfxs
  • Rotate table using 1 formula ADDRESS
  • Shapes with dynamic output Excel User tips
  • Fx to cut long column into two columns Formulas - combined functions
  • When Excel tells you to go get some life 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

  • Zipcode-State search Formulas - combined functions
  • DayName Date and Time
  • Always get 1st name (or last) Formulas - combined functions
  • Count Unique COUNTIF
  • Looplist – Repeating months using formulas Basic Math
  • IFS (and IFNA) to avoid nested IFs Formulas - combined functions

Leave a Reply Cancel reply

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

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
  • CTRL+Y a mini macro Excel User tips
  • Count cells with condition – multiple conditions COUNTIFS
  • Cell formats 0.0\% and 0.0%;(0.0%) Format Cells
  • Scorring, saving multiple outputs in 1 number Basic Math
  • CamelCase to Camel Case CHAR
  • MID + SEARCH to convert cell to rows MID
  • Sum of divide – Array formula Array formula
  • Extract Address into table Formulas - combined functions

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme