Apache Openoffice Calc Tutorial Lower Function Apache Openoffice 4 Calc

Usage:

Usage: right

Usage: proper

Usage: Returns the smallest value in a set of values. Syntax: min(number1, [number2], ...)

Usage: char

Usage: maxa

Usage: fixed

Usage: LEN returns the number of characters in a text string. Syntax: LEN(text)

Usage: Substitutes new_text

Usage: REPLACE

Usage: mina

Usage: exact

Usage: countblank

Usage: isnontext

Usage: checks the specified number is odd number or not and returns TRUE or FALSE. Syntax: isodd(number)

Usage: concatenate

Usage: isblank

Usage: code

Usage: checks the specified number is even number or not and returns TRUE or FALSE. Syntax: iseven(number)