Excel Functions Flashcards
ABS()
Returns the absolute value of a number. The absolute value of a number is the number without its sign e.g. |-x|= x
Syntax: ABS(x) where x is the real number of which you want the absolute value.
EXAMPLES:
ABS(2) = 2
ABS(-2) = 2
If A1 contains -16, then:
SQRT(ABS(A1)) = 4
AVERAGE()
Returns the average (arithmetic mean) of the arguments.
Syntax: AVERAGE(num1, num2, …) where num1, num2, are up to 30 numeric arguments for which you want the average. Any non-numerical values or referencing values are ignored (except for cells with a value of 0).
COS()
Returns the cosine of the given angle.
Syntax: COS(angle) where angle is in RADIANS
COUNT()
Counts the number of cells that contain numbers within the list of arguments. Use COUNT() to get the number of entries in a number field in a range or array of numbers.
Syntax: COUNT(value1, value2, …) where value1, value2 are up to 30 arguments that can contain or refer to a variety of different types of data, but ONLY NUMBERS ARE COUNTED.
INT()
Rounds a number DOWN to the nearest integer.
Syntax: INT(number) where number is the real number you want to round down to an integer.
EXAMPLES:
INT(8.9) = 8
INT(-8.9) = -9 (be careful with negatives!)
MAX()
Returns the largest value in a set of values.
Syntax: MAX(num1, num2, …) where num1 and num2 are 1 to 30 numbers for which you want to find the maximum value of.
specifically numerical values
MIN()
Returns the smallest number in a set of values.
Syntax: MIN(num1, num2, …) where num1, num2 are 1 to 30 numbers for which you want to find the minimum value of.
specifically numerical values
PI()
Returns the irrational number pi, accurate to 15 digits (3.14159265358979).
SIN()
Returns the sine of the given angle.
Syntax: SIN(x), where x is the angle in RADIANS for which you want the sine.
SQRT()
Returns a positive square root.
Syntax: SQRT(number), where number is the POSITIVE number for which you want the square root (if number is negative, SQRT() returns the #NUM! error value).
SUM()
Adds all the numbers in a range of cells.
Syntax: SUM(num1, num2, …)
Numbers, logical values, and text representations of numbers that you type directly into the list of arguments are counted.
AND()
Returns TRUE if all its arguments are TRUE; returns FALSE if one or more arguments is FALSE.
Syntax: AND(logical1, logical2, …) up to 30 conditions (either TRUE or FALSE). All arguments must be boolean values.
IF()
Returns one value if a condition you specify evaluates to TRUE and another value if it evaluates to FALSE.
Syntax: IF(logical_test, value_if_true, value_if_false)
~ logical_test is any value or expression that can be evaluated to TRUE or FALSE
~ value_if_true is the value that is returned if logical_test is TRUE
~ value_if_false is the value that is returned if logical_test is FALSE
OR()
Returns TRUE if any argument is TRUE; returns FALSE if all arguments are FALSE.
Syntax: OR(logical1, logical2, …) <- up to 30 conditions you want to test that can be either TRUE or FALSE.
NOT()
Reverses the value of its argument. Use NOT() when you want to make sure a value is not equal to one particular value.
Syntax: NOT(logical), where logical is a value or expression that can be evaluated to TRUE or FALSE. If logical = FALSE, NOT() returns TRUE; if logical = TRUE, NOT() returns FALSE.
EXAMPLES:
NOT(FALSE) = TRUE
NOT(1+1=2) = FALSE
