Manuals/calci/GEOMETRICSERIES

From ZCubes Wiki
Revision as of 16:46, 11 January 2019 by Devika (talk | contribs) (→‎See Also)
Jump to navigation Jump to search
GEOMETRICSERIES (Start,CommonRatio,Numbers,OnlyNth)


  • is the minimum number of the series.
  • is the difference of the two numbers in the series.


Description

  • This function returns the value of the Geometric Series.
  • In , is the Initial number of the geometric series.
  • is the difference between the numbers.
  • is the number of the terms to display.
  • means it will show the final term of the series.
  • Geometric series means a series of numbers or quantities in geometric progression.
  • So it is the ratio of successive terms in the series is constant.
  • Geometric series using only two terms r and a.
  • The term r is the common ratio,and a is the first term of the series.
  • The sum of the first n terms of a geometric series is:

with and

  • This function will return the result as Error when the parameters are non-numeric.

Examples

  1. GEOMETRICSERIES(3,4,8) = 3 12 48 192 768 3072 12288 49152
  2. GEOMETRICSERIES(3,4,8,5) = 49152
  3. GEOMETRICSERIES(60.5,9,7) = 60.5 544.5 4900.5 44104.5 396940.5 3572464.5 32152180.5

Related Videos

Geometric Series

See Also

References