Difference between revisions of "Manuals/calci/CHAR"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''CHAR'''(Number) where, '''Number''' - is the number for which character you want. </div> ---- <div id...")
 
Line 1: Line 1:
<div id="6SpaceContent" class="zcontent" align="left">
+
<div style="font-size:30px">'''CHAR(nb)'''</div><br/>
  
'''CHAR'''(Number)
+
*where  Nb is the number from 1 to 255.
  
where,
+
==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.
  
'''Number''' - is the number for which character you want.
+
**<math>=COMPLEX(5,2)</math> gives <math>5+2i</math>
 
+
**<math>=COMPLEX(5,2,"j")</math> gives <math>5+2j</math>
</div>
 
----
 
<div id="1SpaceContent" class="zcontent" align="left">Returns the character by a numeric code. </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">
 
 
 
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">
 
  
 +
==Examples==
 
{| id="TABLE3" class="SpreadSheet blue"
 
{| id="TABLE3" class="SpreadSheet blue"
 
|- class="even"
 
|- class="even"
| class=" " |
+
| Complex(RN,IN,SF)
| Column1
+
! RN
| Column2
+
! IN
| Column3
+
! SF
| Column4
+
! RESULT
 +
|-
 
|- class="odd"
 
|- class="odd"
| class=" " | Row1
+
|Complex(5,6)
| class="sshl_f" | 255
+
|5
| class="sshl_f" | ~
+
|6
|
 
 
|
 
|
 +
|5+6i
 
|- class="even"
 
|- class="even"
| class=" " | Row2
+
|Complex(5,2,"j")
| class="sshl_fSelectTD ChangeBGColor SelectTD " |
+
|5
<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>ÿ
+
|2
| class="  " |
+
|j
|
+
|5+6j
|
 
 
|- class="odd"
 
|- class="odd"
| Row3
+
| Complex(2,0,"i")
| class="   " |
+
|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
|
 
|
 
|
 
|- class="even"
 
| Row6
 
|
 
|
 
|
 
 
|
 
|
 +
|j
 +
|Error
 
|}
 
|}
  
<div align="left">[[Image:calci1.gif]]</div></div>
+
==See Also==
----
+
 
 +
*[[Manuals/calci/IMAGINARY | IMAGINARY]]
 +
*[[Manuals/calci/IMREAL| IMREAL]]
 +
 
 +
==References==
 +
[http://en.wikipedia.org/wiki/Complex_number| Complex Numbers]

Revision as of 03:42, 11 November 2013

CHAR(nb)


  • 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.
    • gives
    • 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 =COMPLEX(5,2,"j")} gives

Examples

Complex(RN,IN,SF) RN IN SF RESULT
Complex(5,6) 5 6 5+6i
Complex(5,2,"j") 5 2 j 5+6j
Complex(2,0,"i") 2 0 i 2
Complex(0,-4,i) 0 4 i 4i
Complex(5,"j") 5 j Error

See Also

References

Complex Numbers