Description:
Write a number with the Chinese numerals.
Syntax:
chn(x)
Note:
The function writes a number x according to the number system based on Chinese characters that correspond to numerals in spoken language.
Parameter:
|
x |
When no options are present or when @a and @u options work, parameter x should be an integer; When @b option works, parameter x should be float type. |
Option:
|
@a |
Write the specific number with the Chinese number 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: 壹佰元整. |