Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Unix DateTime Number Basic Math
  • Get column name (columnname as A,B,C, etc) as input inside cell ADDRESS
  • Searching table in 2 dimensions. Formulas - combined functions
  • Workdays – Across months DATE
  • Min Max vehicle Formulas - combined functions
  • Get monthly total from table with dates DATE
  • Cell formats 0.0\% and 0.0%;(0.0%) Format Cells
  • Looplist – Repeating months using formulas Basic Math

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

  • Jan8 date format AND
  • Min Max vehicle Formulas - combined functions
  • Looplist – Repeating months using formulas Basic Math
  • Middle name + 1st name Basic Math
  • iframe in Excel (XLiFrame) ADDRESS
  • Calculate hours between two cells ABS

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
  • Highlight dates dynamically AND
  • BMI Calculator Basic Math
  • LastSunday, LastSaturday Date and Time
  • Always get 1st name (or last) Formulas - combined functions
  • Scorring, saving multiple outputs in 1 number Basic Math
  • When Excel functions are not enough Excel User tips
  • Get monthly total from table with dates DATE
  • Repeated Offset Basic Math

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme