ZCubes Wiki

Difference between revisions of "Manuals/calci/FIBONNACI"

(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''FIBONNACI'''(SomeNumber) where '''SomeNumber '''is any real number </div> ---- <div id="1SpaceContent"...")
 
 
(9 intermediate revisions by 4 users not shown)
Line 1: Line 1:
−
<div id="6SpaceContent" class="zcontent" align="left">
+
=FIBONNACI (NumberUpto)=
 +
where,
 +
*<math>NumberUpto</math> is any real number.
 +
**FIBONNACI(), returns the fibonnaci sequence.
  
−
'''FIBONNACI'''(SomeNumber)
+
== Description ==
  
−
where
+
FIBONNACI(NumberUpto) or FIBONACCI(NumberUpto)
  
−
'''SomeNumber '''is any real number
+
e.g.
 +
FIBONNACI(3) returns ''0, 1, 1, 2'' as a result.
  
−
</div>
+
FIBONACCI(6) returns ''0, 1, 1, 2, 3, 5, 8'' as a result.
−
----
 
−
<div id="1SpaceContent" class="zcontent" align="left">
 
  
−
Calci returns the FIBONNACI series upto the given number, SomeNumber.
+
*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 -
  
−
</div>
+
0, 1, 1, 2, 3, 5, 8, 13, 21, 34, 55, 89, 144, .......
−
----
+
−
<div id="7SpaceContent" class="zcontent" align="left">
+
*Argument <math>NumberUpto</math> specifies the count of numbers for which the sequence is to be displayed.
  
−
FIBONNACI returns NaN if SomeNumber is not a real number
+
e.g. if <math>NumberUpto</math> is '3', Calci displays Fibonacci series up to 3 numbers excluding '0'.
 +
*If <math>NumberUpto</math> &lt; zero(0), Calci displays #NULL error message.
 +
*If <math>NumberUpto</math> is not an integer, Calci rounds it up to display the result.
  
−
</div>
+
*Both spellings supported - FIBONNACI(NumberUpto) or FIBONACCI(NumberUpto)
−
----
+
−
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
+
== Examples ==
  
−
FIBONNACI
+
<div id="6SpaceContent" class="zcontent" align="left">
−
 
 
−
</div></div>
 
−
----
 
−
<div id="8SpaceContent" class="zcontent" align="left">
 
−
 
 
−
Lets see an example in (Column2Row1)
 
−
 
 
−
<nowiki>=FIBONNACI(Column1Row1)</nowiki>
 
−
 
 
−
Returns 0,1,1,2  for FIBONNACI(3)
 
−
 
 
−
</div>
 
−
----
 
−
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
 
−
----
 
−
<div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div>
 
−
----
 
−
<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
 
−
----
 
−
<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
 
−
----
 
−
<div id="2SpaceContent" class="zcontent" align="left">
 
  
 
{| id="TABLE3" class="SpreadSheet blue"
 
{| id="TABLE3" class="SpreadSheet blue"
−
|+ Default Calci
 
 
|- class="even"
 
|- class="even"
−
| class=" " |
+
| class=" " | '''Function'''
−
| Column1
+
| class="  " | '''Output'''
−
| Column2
+
 
−
| Column3
 
−
| Column4
 
 
|- class="odd"
 
|- class="odd"
−
| class=" " | Row1
+
| class="sshl_f" |FIBONNACI(5)
−
| class=" " | 3
+
| class="sshl_f" |0, 1, 1, 2, 3, 5
−
| class="1    " | 0,1,1,2
+
 
−
| class="                    sshl_f" |
 
−
| class="                                                          sshl_f  sshl_f" |
 
 
|- class="even"
 
|- class="even"
−
| class=" " | Row2
+
| class="sshl_f" |FIBONNACI(6)
−
| class="1      SelectTD1  sshl_t  SelectTD1 ChangeBGColor" |
+
| class="sshl_f" |0, 1, 1, 2, 3, 5, 8
−
<div id="2Space_Handle" class="zhandles" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" class="zhandles" title="Click and Drag over to AutoFill other cells."></div><div id="2Space_Drag" class="zhandles" title="Click and Drag to Move/Copy Area.">[[Image:copy-cube.gif]]  </div>
+
 
−
| class="1                                        sshl_f   " |
 
−
| class=" sshl_f" |
 
−
| class="sshl_f  sshl_f" |
 
 
|- class="odd"
 
|- class="odd"
−
| Row3
+
| class="sshl_f" |FIBONNACI(5.4)
−
|
+
| class="sshl_f" |0, 1, 1, 2, 3, 5, 8
−
| class="sshl_f" |
+
 
−
| class="sshl_f   " |
 
−
| class="sshl_f" |
 
 
|- class="even"
 
|- class="even"
−
| Row4
+
| class="sshl_f" |FIBONACCI(6)
−
|
+
| class="sshl_f" |0, 1, 1, 2, 3, 5, 8
−
| class="sshl_f" |
+
 
−
| class="sshl_f" |
 
−
|
 
−
|- class="odd"
 
−
| class=" " | Row5
 
−
|
 
−
|
 
−
| class="sshl_f" |
 
−
|
 
−
|- class="even"
 
−
| Row6
 
−
|
 
−
|
 
−
| class="sshl_f" |
 
−
|
 
 
|}
 
|}
  
−
{|
+
==Related Videos==
−
| <span align="left">[[Image:calci1.gif]]</span>
+
 
−
|
+
{{#ev:youtube|Bdbc1ZC-vhw|280|center|FIBONNACI}}
−
|
+
 
−
[[Image:bold.gif]]
+
== See Also ==
−
|
+
 
−
[[Image:italic.gif]]
+
*[[Manuals/calci/NSTEPFIBONACCI | NSTEPFIBONACCI]]
−
|
+
*[[Manuals/calci/NSTEPFIBONACCI| TRIBONACCI]]
−
[[Image:normal.gif]]
+
*[[Manuals/calci/NSTEPFIBONACCI| TETRANACCI]]
−
|
+
*[[Manuals/calci/NSTEPFIBONACCI| PENTANACCI]]
−
[[Image:underline.gif]]
+
*[[Manuals/calci/NSTEPFIBONACCI| HEXANACCI]]
−
|
+
*[[Manuals/calci/NSTEPFIBONACCI| HEPTANACCI]]
−
[[Image:border.gif]]
+
*[[Manuals/calci/FACT | FACT]]
−
|
+
 
−
[[Image:numbers.gif]]
+
== References ==
−
|
+
 
−
[[Image:sort.gif]]
+
*[http://en.wikipedia.org/wiki/Fibonacci_number Fibonacci Numbers]
−
|
+
 
−
[[Image:formatcells.gif]]
+
 
−
|
+
 
−
[[Image:graphs.gif]]
+
*[[Z_API_Functions | List of Main Z Functions]]
−
| $
 
−
|}
 
  
−
</div>
+
*[[ Z3 |  Z3 home ]]
−
----
 

Latest revision as of 14:57, 16 February 2020

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


Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/FIBONNACI&oldid=212929"