Administrators, writer
3,314
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + − '''CHAR'''(Number)+ − where,+ + + + + − '''Number''' - is the number for which character you want.+ − + − − ---- − <div id="1SpaceContent" class="zcontent" align="left">Returns the character by a numeric code. </div> − ---- − − ---- − − − CHAR − − </div></div> − ---- − <div id="8SpaceContent" class="zcontent" align="left"> − − Lets see an example in (Column1, Row2) − − <nowiki>=CHAR(R1C1)</nowiki> − − It returns ÿ. − − Consider an another example in (Column2,Row1) − − <nowiki>=CHAR(126)</nowiki> − − CHAR returns ~. − − </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"> + − + − | Column1+ − | Column2+ − | Column3+ − + + − + − + − | class="sshl_f" | ~+ − + − + − + − <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=" " |+ − + − + − + − + − + − + − + − + − + − |+ − | − | − | − |- class="even" − | Row6 − | − | − + + − <div align="left">[[Image:calci1.gif]]</div></div>+ − ----+ + + + + +
no edit summary
<div id="6SpaceContent" class="zcontent" align="left">
<div style="font-size:30px">'''CHAR(nb)'''</div><br/>
*where Nb is the number from 1 to 255.
==Description==
*This function gives the ANSI chracters for given Number.
*Function CHAR is used to give the spcific character for the number.
*Also the number is between 1 to 255.The Nb can be a number directly or indirectly like cell reference.
*The character is from the character set using in our system.
**<math>=COMPLEX(5,2)</math> gives <math>5+2i</math>
**<math>=COMPLEX(5,2,"j")</math> gives <math>5+2j</math>
</div>
<div id="7SpaceContent" class="zcontent" align="left">It varies according to Operating environment.</div>
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
==Examples==
{| id="TABLE3" class="SpreadSheet blue"
{| id="TABLE3" class="SpreadSheet blue"
|- class="even"
|- class="even"
| class=" " |
| Complex(RN,IN,SF)
! RN
! IN
! SF
| Column4
! RESULT
|-
|- class="odd"
|- class="odd"
| class=" " | Row1
|Complex(5,6)
| class="sshl_f" | 255
|5
|6
|
|
|
|5+6i
|- class="even"
|- class="even"
| class=" " | Row2
|Complex(5,2,"j")
| class="sshl_fSelectTD ChangeBGColor SelectTD " |
|5
|2
| class=" " |
|j
|
|5+6j
|
|- class="odd"
|- class="odd"
| Row3
| Complex(2,0,"i")
|2
|
|0
|
|i
|
|2
|- class="even"
|- class="even"
| Row4
| Complex(0,-4,i)
|
|0
|
|4
|
|i
|
|4i
|- class="odd"
|- class="odd"
| class=" " | Row5
|Complex(5,"j")
|5
|
|
|
|j
|Error
|}
|}
==See Also==
*[[Manuals/calci/IMAGINARY | IMAGINARY]]
*[[Manuals/calci/IMREAL| IMREAL]]
==References==
[http://en.wikipedia.org/wiki/Complex_number| Complex Numbers]