Description:
Write a number with the Chinese numerals.
Syntax:
chn(x)
Note:
The function writes a number x according to the numeral system based on Chinese characters that correspond to numerals in spoken language.
Parameter:
|
x |
If a function doesn’t work with an option or uses @a and @u options, parameter x should be an integer; if it works with @b option, parameter x should be a float |
Option:
|
@a |
Write the specific number with the Chinese numeral system in the format of billion, ten thousand, thousand, hundred, ten in order |
|
@u |
Write the specific number with upper case Chinese numerals |
|
@b |
Write the specific number using Chinese characters used for numbers on renminbi banknotes |
Example:
|
|
A |
|
|
1 |
=chn(97) |
Result:九七. |
|
2 |
=chn(-97) |
Result:负九七. |
|
3 |
=chn@a(128) |
Result: 一百二十八. |
|
4 |
=chn@a(-2594) |
Result: 负二千五百九十四. |
|
5 |
=chn@u(128) |
Result: 壹贰捌. |
|
6 |
=chn@u(-128) |
Result: 负壹贰捌. |
|
7 |
=chn@b(1238.35) |
Result: 一千二百三十八元三角五分. |
|
8 |
=chn@ub(100) |
Result: 壹佰元整. |