Difference between revisions of "Manuals/calci/CHAR"
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 | + | <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> | |
| − | < | ||
| − | |||
| − | |||
| − | |||
| − | < | ||
| − | |||
| − | < | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| + | ==Examples== | ||
{| id="TABLE3" class="SpreadSheet blue" | {| id="TABLE3" class="SpreadSheet blue" | ||
|- class="even" | |- class="even" | ||
| − | | | + | | Complex(RN,IN,SF) |
| − | + | ! RN | |
| − | + | ! IN | |
| − | + | ! SF | |
| − | | | + | ! RESULT |
| + | |- | ||
|- class="odd" | |- class="odd" | ||
| − | | | + | |Complex(5,6) |
| − | | | + | |5 |
| − | + | |6 | |
| − | | | ||
| | | | ||
| + | |5+6i | ||
|- class="even" | |- class="even" | ||
| − | | | + | |Complex(5,2,"j") |
| − | | | + | |5 |
| − | + | |2 | |
| − | | | + | |j |
| − | | | + | |5+6j |
| − | | | ||
|- class="odd" | |- class="odd" | ||
| − | | | + | | Complex(2,0,"i") |
| − | + | |2 | |
| − | | | + | |0 |
| − | | | + | |i |
| − | | | + | |2 |
|- class="even" | |- class="even" | ||
| − | | | + | | Complex(0,-4,i) |
| − | | | + | |0 |
| − | | | + | |4 |
| − | | | + | |i |
| − | | | + | |4i |
|- class="odd" | |- class="odd" | ||
| − | | | + | |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] | ||
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 (syntax error): {\displaystyle =COMPLEX(5,2,"j")} gives
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 |