Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Series

Use this function to populate a series of values into a range of cells. Must be used in conjunction with the BY function.

Copy

Syntax

SERIES ([Num1 of] Value1 [, [Num2 of] Value2]...[, NumX of] ValueX])        

where:

  • Value specifies the number of times, starting at the first symbol and continuing until either the limit of the BY dimension range is reached or there are no more values to insert, to repeat to create the range. Used alone, Value may be any floating point or integer value.
  • Num must be a positive integer, used with a Value that is a floating point number.
Copy

Syntax example

Symbol = Series (2 of 1, 3 of 2)                

See also
Published:

Series

Use this function to populate a series of values into a range of cells. Must be used in conjunction with the BY function.

Copy

Syntax

SERIES ([Num1 of] Value1 [, [Num2 of] Value2]...[, NumX of] ValueX])        

where:

  • Value specifies the number of times, starting at the first symbol and continuing until either the limit of the BY dimension range is reached or there are no more values to insert, to repeat to create the range. Used alone, Value may be any floating point or integer value.
  • Num must be a positive integer, used with a Value that is a floating point number.
Copy

Syntax example

Symbol = Series (2 of 1, 3 of 2)                

See also
For an optimal Community experience, Please view on Desktop