REPT Function (Functions in Excel)

Text To Repeat	Number Of Repeats	Repeated Text
A	3	AAA	=REPT(C4,D4)
AB	3	ABABAB	=REPT(C5,D5)
-	10	----------	=REPT(C6,D6)
|	10	||||||||||	=REPT(C7,D7)

What Does It Do ?

This function repeats a piece of text a specified number of times.

You need to specify the text to be repeated and how many times to repeat it.

Syntax

=REPT(TextToRepeat,Repetitions)

The maximum number of repetitions is 200.

Formatting

No special formatting is needed.

Example 1

The following table was used to display a simple histogram of sales figures.

The =REPT() function uses the value of Sales, but this is divided by 100 to scale down the

number of repetitions to below the maximum of 200.

Month	Sales
Jan	£1,000	||||||||||||||||||||
Feb	£5,000	||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Mar	£3,000	||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Apr	£2,000	||||||||||||||||||||||||||||||||||||||||
		=REPT("||",D29/100)

Example 2

The =REPT() function has been used to make a digital display for the current time.

The time functions of =HOUR(), =MINUTE() and =SECOND() have been used in conjunction

with the =NOW() as the basis for the number of repeats.

To update the clock press the function key F9.

Clock
Hour	|||||||||||||| 14
Minute	|||||||||||||||||||||||||||||||||||||||||||||||||| 50
Second	|||||||||||||||||||||||||||| 28
	=REPT("|",HOUR(NOW()))&" "&TEXT(HOUR(NOW()),"00")
	=REPT("|",MINUTE(NOW()))&" "&TEXT(MINUTE(NOW()),"00")
	=REPT("|",SECOND(NOW()))&" "&TEXT(SECOND(NOW()),"00")

Related Posts by Categories