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.
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.
No comments:
Post a Comment