Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Skills Grid Conditional Formatting
  • Worksheet name, dynamically using formula CELL
  • New function IFERROR, finally IFERROR
  • Cuts string of list of items Formulas - combined functions
  • Multiple lines in cell using functions CHAR
  • Always get 1st name (or last) Formulas - combined functions
  • WorksheetName and WorksheetsNo UDFs Lookup and References
  • Paste Special Percentage Excel User tips

Category: REPT

Fixed length ID

Posted on January 22, 2019 By ANmar
Fixed length ID

I needed few months back to make a fixed-length ID iut if none-fixed-length numbers.

SO I used the function REPT with RIGHT to force all numbers to be converted into fixed-length ID (mainly having leading zeros)

And here is the formula

Read More “Fixed length ID” »

Formulas - combined functions, REPT, RIGHT, Texts and Strings

Progress bar in pure functions

Posted on January 29, 2012 By ANmar No Comments on Progress bar in pure functions
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

Tally chart in functions

Posted on January 26, 2012 By ANmar No Comments on Tally chart in functions
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

Recent Posts

  • Stale values (Scratched functions)
  • Middle name + 1st name
  • LastSunday, LastSaturday
  • Paste Special Percentage
  • Jan8 date format

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 (82)
    • 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 (30)
      • AND (5)
      • IF (24)
      • IFERROR (6)
      • 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 (5)
      • 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
  • Search across sheets in function ADDRESS
  • Edit directly in cell Excel User tips
  • Zipcode-State search Formulas - combined functions
  • Convert cell into textbox Excel User tips
  • Sum of divide – Array formula Array formula
  • Min Max vehicle Formulas - combined functions
  • IFS (and IFNA) to avoid nested IFs Formulas - combined functions
  • When Excel functions are not enough Excel User tips

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme