Manuals/calci/FIBONNACI

Revision as of 16:16, 15 June 2018 by Devika (talk | contribs)

FIBONNACI (NumberUpto)

where,

  •   is any real number.

FIBONNACI() Returns the fibonnaci sequence

Description

FIBONNACI(NumberUpto) or FIBONACCI(NumberUpto)

e.g. FIBONNACI(3) returns 0, 1, 1, 2 as a result.

FIBONACCI(6) returns 0, 1, 1, 2, 3, 5, 8 as a result.

  • Fibonacci sequence is a series of numbers in which, after first two numbers each subsequent number is the sum of the previous two numbers.
  • Fibonacci sequence is as follows -

0, 1, 1, 2, 3, 5, 8, 13, 21, 34, 55, 89, 144, .......

  • Argument   specifies the count of numbers for which the sequence is to be displayed.

e.g. if   is '3', Calci displays Fibonacci series up to 3 numbers excluding '0'.

  • If   < zero(0), Calci displays #NULL error message.
  • If   is not an integer, Calci rounds it up to display the result.
  • Both spellings supported - FIBONNACI(NumberUpto) or FIBONACCI(NumberUpto)

Examples

Function Output
FIBONNACI(5) 0, 1, 1, 2, 3, 5
FIBONNACI(6) 0, 1, 1, 2, 3, 5, 8
FIBONNACI(5.4) 0, 1, 1, 2, 3, 5, 8
FIBONACCI(6) 0, 1, 1, 2, 3, 5, 8

Related Videos

FIBONNACI

See Also

References