Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Zipcode-State search Formulas - combined functions
  • Custom fiscal year calendar (CFlex) Basic Math
  • Multiple lines in cell using functions CHAR
  • Multiple Dual-Validations COUNTA
  • Comments versus Notes Excel User tips
  • LastSunday, LastSaturday Date and Time
  • UDF – Convert Number into text (English and Arabic) User-Defined f(x)s = UDF
  • When Excel tells you to go get some life 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

  • 6174 Kaprekar’s constant Basic Math
  • Excel @ before function names in formulas Excel User tips
  • LastSunday, LastSaturday Date and Time
  • Search across sheets in function ADDRESS
  • Min Max vehicle Formulas - combined functions
  • iframe in Excel (XLiFrame) ADDRESS

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
  • Get column name (columnname as A,B,C, etc) as input inside cell ADDRESS
  • Stale values (Scratched functions) Excel User tips
  • Spreadsheet Compare application Excel User tips
  • Paste Special Percentage Excel User tips
  • CTRL+Y a mini macro Excel User tips
  • When Excel functions are not enough Excel User tips
  • Walking Columns ActiveX controls
  • Comments versus Notes Excel User tips

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme