Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • iframe in Excel (XLiFrame) ADDRESS
  • Jan8 date format AND
  • Why I ran from =INDIRECT() function Formulas - combined functions
  • IFS (and IFNA) to avoid nested IFs Formulas - combined functions
  • Edit directly in cell Excel User tips
  • Highlight dates dynamically AND
  • VLookup Lookup and References
  • Cells with additional spaces AND

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

  • Expenses calendar, FaCal Basic Math
  • Fixed length ID Formulas - combined functions
  • GoLast to jump to last cell in a column CELL
  • Jan8 date format AND
  • Validation based on another Validation COUNTA
  • Rotate table using 1 formula 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
  • CONVERT function CONVERT
  • Count how many times letter found Formulas - combined functions
  • VALUE() of LEFT() Formulas - combined functions
  • FORMULATEXT to show formulas FORMULATEXT
  • Lesson learned: Do not trust Google Sheets function Google Sheets
  • Sort list dynamically (functions) COLUMN
  • Standard math to calculate Aspect Ratio Basic Math
  • 6174 Kaprekar’s constant Basic Math

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme