Apache Openoffice Calc Tutorial Maxa Function Apache Openoffice 4 Calc

Usage:

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

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

Usage: right

Usage: char

Usage: fixed

Usage: proper

Usage: REPLACE

Usage: Substitutes new_text

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

Usage:

Usage: lower

Usage: exact

Usage: count

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

Usage: checks the specified value is valid number or not and returns TRUE or FALSE Syntax: isnumber(text/number)

Usage: countblank

Usage: isnontext

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

Usage: code