Your web browser is not supported.

Some features may not work correctly.

Using functions

The permanent link has been copied.

Article number:040847

Articles in this category

IF function: Change the value to display depending on a condition
AND, OR, and NOT functions: Combine conditions
SUM function: Calculate the total of numeric values
ROUND, ROUNDUP, and ROUNDDOWN functions: Round off, round up, and round down numeric values
Setting the round off, round down, or round up
DATE_FORMAT function: Specifying the display format of date and time
Calculation of date, time, and date and time
CONTAINS function: Determine if a field contains an exact match for a specified character string
& operator: Concatenating strings and numbers
YEN function: Display calculation results rounded and in Japanese yen
Calculating fields in tables