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.
Output Result
'Total' value '100000' is shown in specified format.
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.
Output Result
3.CONCATENATE(string1,string2, …, stringN)
Returns united string with string1, string2, …, stringN.
Input String
Enter character string to unite.
Output Result
Specified character string is displayed.