Difference between revisions of "Manuals/calci/FIBONNACI"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''FIBONNACI'''(SomeNumber) where '''SomeNumber '''is any real number </div> ---- <div id="1SpaceContent"...")
 
Line 1: Line 1:
−
<div id="6SpaceContent" class="zcontent" align="left">
+
=FIBONNACI(SomeNumber)=
  
−
'''FIBONNACI'''(SomeNumber)
+
where,
 +
*<math>SomeNumber</math> is any real number.
  
−
where
+
FIBONNACI() displays the Fibonacci series up to the specified number as argument.
  
−
'''SomeNumber '''is any real number
+
== Description ==
  
−
</div>
+
FIBONACCI(SomeNumber)
−
----
 
−
<div id="1SpaceContent" class="zcontent" align="left">
 
  
−
Calci returns the FIBONNACI series upto the given number, SomeNumber.
+
e.g.
 +
FIBONNACI(3) returns ''0, 1, 1, 2'' as a result.
  
−
</div>
+
*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 id="7SpaceContent" class="zcontent" align="left">
 
  
−
FIBONNACI returns NaN if SomeNumber is not a real number
+
0, 1, 1, 2, 3, 5, 8, 13, 21, 34, 55, 89, 144, .......
 +
 +
*Argument <math>SomeNumber</math> specifies the count of numbers for which the sequence is to be displayed.
  
−
</div>
+
e.g. if <math>SomeNumber</math> is '3', Calci displays Fibonacci series up to 3 numbers excluding '0'.
−
----
+
*If <math>SomeNumber</math> &lt; zero(0), Calci displays #NULL error message.
−
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
+
*If <math>SomeNumber</math> is not an integer, Calci rounds it up to display the result.
 +
 +
== 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"
 
−
| Row4
 
−
|
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
|
 
−
|- class="odd"
 
−
| class=" " | Row5
 
−
|
 
−
|
 
−
| class="sshl_f" |
 
−
|
 
−
|- class="even"
 
−
| Row6
 
−
|
 
−
|
 
−
| class="sshl_f" |
 
−
|
 
 
|}
 
|}
  
−
{|
+
== See Also ==
−
| <span align="left">[[Image:calci1.gif]]</span>
+
 
−
|
+
*[[Manuals/calci/FACTORIAL | FACTORIAL]]
−
|
+
 
−
[[Image:bold.gif]]
+
== References ==
−
|
 
−
[[Image:italic.gif]]
 
−
|
 
−
[[Image:normal.gif]]
 
−
|
 
−
[[Image:underline.gif]]
 
−
|
 
−
[[Image:border.gif]]
 
−
|
 
−
[[Image:numbers.gif]]
 
−
|
 
−
[[Image:sort.gif]]
 
−
|
 
−
[[Image:formatcells.gif]]
 
−
|
 
−
[[Image:graphs.gif]]
 
−
| $
 
−
|}
 
  
−
</div>
+
*[http://en.wikipedia.org/wiki/Fibonacci_number Fibonacci Numbers]
−
----
 

Revision as of 16:26, 22 February 2014

FIBONNACI(SomeNumber)

where,

  • is any real number.

FIBONNACI() displays the Fibonacci series up to the specified number as argument.

Description

FIBONACCI(SomeNumber)

e.g. FIBONNACI(3) returns 0, 1, 1, 2 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.

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

See Also

References

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