chn()

Read(2257) Label: chinese numerals,

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: 壹佰元整.