Difference between revisions of "Manuals/calci/CHAR"
Jump to navigation
Jump to search
| Line 23: | Line 23: | ||
|- | |- | ||
|- class="odd" | |- class="odd" | ||
| − | | | + | |CHAR(Nb) |
| − | | | + | |3000 |
| − | | | + | |ஸ |
|- class="even" | |- class="even" | ||
| − | | | + | |CHAR(Nb) |
| − | | | + | |100 |
| − | | | + | |d |
|- class="odd" | |- class="odd" | ||
| − | | | + | | CHAR(Nb) |
| − | | | + | |58 |
| − | | | + | |: |
|- class="even" | |- class="even" | ||
| − | | | + | | CHAR(Nb) |
|0 | |0 | ||
|4 | |4 | ||
|- class="odd" | |- class="odd" | ||
| − | | | + | |CHAR(Nb) |
| − | | | + | |33 |
| − | | | + | |! |
|} | |} | ||
Revision as of 04:38, 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 |
|---|---|---|
| CHAR(Nb) | 3000 | ஸ |
| CHAR(Nb) | 100 | d |
| CHAR(Nb) | 58 | : |
| CHAR(Nb) | 0 | 4 |
| CHAR(Nb) | 33 | ! |