Sample of Function Usage

1.FORMAT_NUMBER(x, format)

This is a Function to return character string which is characterized by numeric x format.

Input formula
We format the entered numeric number in 'Total' as '#,##0'. Also by using Operato '||' and display '$' in front of number.
Expression Editor

Output Result
'Total' value '100000' is shown in specified format.
Output Result

 

2.ROUND(x, n)

Return a number after round off by numeric number x decimal number n. When n is ignored, it treats as 0. We show here 'ROUND(x, n)', there are other formula such as 'CEILING(x, n)' and 'FLOOR(x, n)'. 'CEILING(x, n)' rounds up the number x with decimal point of n. 'FLOOR(x, n)' rounds down number x with decimal point of n.

Input String
Will round up with one decimal point by 0.08 to 'Total' number.
Expression Editor

Output Result
Output Result

 

3.CONCATENATE(string1,string2, …, stringN)

Returns united string with string1, string2, …, stringN.

Input String
Enter character string to unite.

Expression Editor

Output Result
Specified character string is displayed.

Output Result

 

Close