Difference between revisions of "Manuals/calci/CHAR"
Jump to navigation
Jump to search
| Line 17: | Line 17: | ||
{| id="TABLE3" class="SpreadSheet blue" | {| id="TABLE3" class="SpreadSheet blue" | ||
|- class="even" | |- class="even" | ||
| − | + | ! CHAR(Nb) | |
| − | ! | + | ! Nb |
| − | + | ! Result | |
| − | ! | + | |
| − | |||
|- | |- | ||
|- class="odd" | |- class="odd" | ||
| Line 27: | Line 26: | ||
|5 | |5 | ||
|6 | |6 | ||
| − | + | ||
| − | |||
|- class="even" | |- class="even" | ||
|Complex(5,2,"j") | |Complex(5,2,"j") | ||
|5 | |5 | ||
|2 | |2 | ||
| − | + | ||
| − | |||
|- class="odd" | |- class="odd" | ||
| Complex(2,0,"i") | | Complex(2,0,"i") | ||
|2 | |2 | ||
|0 | |0 | ||
| − | + | ||
| − | |||
|- class="even" | |- class="even" | ||
| Complex(0,-4,i) | | Complex(0,-4,i) | ||
|0 | |0 | ||
|4 | |4 | ||
| − | + | ||
| − | |||
|- class="odd" | |- class="odd" | ||
|Complex(5,"j") | |Complex(5,"j") | ||
|5 | |5 | ||
| | | | ||
| − | + | ||
| − | |||
|} | |} | ||
Revision as of 04:11, 12 November 2013
CHAR(Nb)
- where Nb is the number from 1 to infinity.
Description
- This function gives the ANSI characters for given Number.
- CHAR()gives a specific character for a number.
- Also the number is between 1 to infinity.
- The Nb can be a number directly or indirectly like cell reference.
- The character is from the character set used in our system.
- CHAR(65)
- CHAR(B5), where B5 is the cell number
- CHAR(100)
Examples
| CHAR(Nb) | Nb | Result |
|---|---|---|
| Complex(5,6) | 5 | 6 |
| Complex(5,2,"j") | 5 | 2 |
| Complex(2,0,"i") | 2 | 0 |
| Complex(0,-4,i) | 0 | 4 |
| Complex(5,"j") | 5 |