Function Description
| Category | Description |
|---|---|
| Function Syntax | REPEAT(text,number_times) |
| Function | Repeats text for the specified number of times. |
| Parameters | text: the text to repeat number_times: the number of times to repeat the text The value of number_times must be a positive number. If the value is 0, the REPEAT function returns "" (empty text). If the value is not an integer, it is rounded down. If the value is a negative number, its absolute value is used. If the value is greater than 200, the function returns #NUM!. |
| Number of Parameters | 2 |
| Parameter Types | Text, number |
| Return Value Type | Text |
| Notes | This function can be used to create a simple histogram in a worksheet. |
Example
| Formula | Result |
|---|---|
REPEAT("$",4) | $$$$ |
REPEAT("$",null) | $ |
REPEAT("$",-4) | $$$$ |