Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Standard math to calculate Aspect Ratio Basic Math
  • Excel @ before function names in formulas Excel User tips
  • CTRL+Y a mini macro Excel User tips
  • Multiple Dual-Validations COUNTA
  • VLookup Lookup and References
  • Jan8 date format AND
  • Excel keeps converting all cells to “Date” (or Time) Excel User tips
  • Min Max vehicle Formulas - combined functions

Progress bar in pure functions

Posted on January 29, 2012 By ANmar No Comments on Progress bar in pure functions

This one is very similar to Tally chart, however, it is for another purpose.

It is used to draw a progress bar, yes a progress bar in pure functions, using the formula:

=REPT( CHAR( 8),INT( D2/10))&REPT( CHAR( 7),INT( D3/10)-INT( D2/10))

CHAR, Formulas - combined functions, INT, REPT, Standard functions, Texts and Strings

Post navigation

Previous Post: Excel Dynamic Drop-Downs that grow with you
Next Post: UDF – Convert Number into text (English and Arabic)

Related Posts

  • Sum of divide – Array formula Array formula
  • Zipcode-State search Formulas - combined functions
  • Cuts string of list of items Formulas - combined functions
  • IF with AND and IF with OR AND
  • Return 12 values in one number AND
  • Links between two workbooks – dynamically using functions INDIRECT

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
  • Extract current (Active) workbook name CELL
  • Links between two workbooks – dynamically using functions INDIRECT
  • Multiple Dual-Validations COUNTA
  • New function IFERROR, finally IFERROR
  • Fixed length ID Formulas - combined functions
  • Standard math to calculate Aspect Ratio Basic Math
  • Excel ad from early 90s Non-functions
  • Pixel Excel Drawing Format Cells

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme