chn()

Read(32) Label: chinese numerals,

Description:

  Write a number with the Chinese numerals.

Syntax:

chn(x)

Note:

  The function writes a number according to the numeral system based on Chinese characters that correspond to numerals in spoken language.

Parameters:

x

If a function doesn’t work with an option or uses @a and @u options, parameter x should be an integer; if it cooperate with @b option, parameter x should be a float

Options:

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