OR( x, y) Returns the value 1 (true) if either or both logical expressions x and y are true, or the value 0 (zero) (false) if both expressions are false. NOT( x) Returns the value 0 (zero) (false) if the logical expression x is true, or the value 1 (true) if the expression is false. MOD( x, y) Returns the remainder that results from dividing the value x by the value y a whole number of times. MAX( ) Returns the largest value in a list. MIN( ) Returns the smallest value in a list. INT( x) Returns the numbers to the left of the decimal place in the value or formula x. DEFINED( x) Returns the value 1 (true) if the expression x is valid, or the value 0 (false) if the expression cannot be computed. COUNT( ) Returns the number of items in a list. AVERAGE( ) Returns the average of a list of values. AND( x, y) Returns the value 1 if the logical expressions x and y are both true, or the value 0 (zero) if either expression is false.
ABS( x) Returns the positive value of a number or formula, regardless of its actual positive or negative value. The functions AVERAGE(), COUNT(), MAX(), MIN(), PRODUCT(), and SUM() can also accept references to table cells as arguments. Arguments can be numbers, formulas, or bookmark names. Functions with empty parentheses can accept any number of arguments separated by commas (,) or semicolons ( ), as long as you use the list separator defined as part of the regional settings in Microsoft Windows Control Panel. The = (Formula) field can use values returned by the following functions.
0 kommentar(er)
