Apache Openoffice Calc Tutorial Istext Function Apache Openoffice 4 Calc

Usage: checks the specified value is valid text or not and returns TRUE or FALSE. Syntax:

Usage: right

Usage: proper

Usage: isnontext

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

Usage: REPLACE

Usage: maxa

Usage: fixed

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

Usage: Substitutes new_text

Usage: isblank

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

Usage: exact

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

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

Usage: count

Usage: lower

Usage: countblank

Usage: concatenate

Usage: code