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,

  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle NumberUpto} 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 Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle NumberUpto} specifies the count of numbers for which the sequence is to be displayed.

e.g. if Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle NumberUpto} is '3', Calci displays Fibonacci series up to 3 numbers excluding '0'.

  • If Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle NumberUpto} < zero(0), Calci displays #NULL error message.
  • If Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle NumberUpto} 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"