Operator Type

Operator Symbols

Comparison

< > = <= >=

Addition/Subtraction

+ -

Multiplication/Division

* /

Power

^

Grouping

( ) , .

Name

Description

Syntax

AND

Returns TRUE if all of its arguments are TRUE

=AND(logical1[, logical2,…])

FALSE

Returns the logical value FALSE

=FALSE

IF

Specifies a logical test to perform

=IF(logical_test, value_if_true, value_if_false)

NOT

Reverses the logic of its argument

=NOT(logical)

OR

Returns TRUE if any argument is TRUE

=OR(logical1[, logical2,…])

TRUE

Returns the logical value TRUE

=TRUE

Name

Description

Syntax

ABS

Returns the absolute value of a number

=ABS(number)

ACOS

Returns the arccosine of a number

=ACOS(number)

ASIN

Returns the arcsine of a number

=ASIN(number)

ATAN

Returns the arctangent of a number

=ATAN(number)

ATAN2

Returns the arctangent from x- and y-coordinates

=ATAN2(x_num, y_num)

CEILING

Rounds a number to the nearest integer or to the nearest multiple of significance

=CEILING(number)

COS

Returns the cosine of a number

=COS(number)

COSH

Returns the hyperbolic cosine of a number

=COSH(number)

EXP

Returns e raised to the power of a given number

=EXP(number)

FLOOR

Rounds a number down, toward zero

=FLOOR(number)

INT

Rounds a number down to the nearest integer

=INT(number)

LN

Returns the natural logarithm of a number

=LN(number)

LOG

Returns the logarithm of a number to a specified base

=LOG(number[, base])

LOG10

Returns the base-10 logarithm of a number

=LOG10(number)

PI

Returns the value of the PI constant

=PI()

POWER

Returns the result of a number raised to a power

=POWER(number, power)

RAND

Returns a random number between 0 and 1

=RAND()

RANDBETWEEN

Returns a random number between the numbers you specify

=RANDBETWEEN(bottom, top)

SIGN

Returns the sign of a number

=SIGN(number)

SIN

Returns the sine of the given angle

=SIN(number)

SINH

Returns the hyperbolic sine of a number

=SINH(number)

SQRT

Returns a positive square root

=SQRT(number)

SUM

Adds its arguments

=SUM(number1[, number2, …])

TAN

Returns the tangent of a number

=TAN(number)

TANH

Returns the hyperbolic tangent of a number

=TANH(number)

TRUNC

Truncates a number to an integer

=TRUNC(number)";

Name

Description

Syntax

AVERAGE

Returns the average of its arguments

AVERAGEA

Returns the average of its arguments, including numbers, text, and logical values

=AVERAGE(number1 [, number2, …])

COUNT

Counts how many numbers are in the list of arguments

=AVERAGEA(number1 [, number2, …])

COUNTA

Counts how many values are in the list of arguments

=COUNT(number1 [, number2, …])

COUNTBLANK

Counts the number of blank cells within a range

=COUNTA(number1 [, number2, …])

COUNTIF

Counts the number of cells within a range that meet the given criteria

=COUNTIF(range, criteria)

MAX

Returns the maximum value in a list of arguments

=MAX(number1 [, number2, …])

MAXA

Returns the maximum value in a list of arguments, including numbers, text, and logical values

=MAXA(number1 [, number2, …])

MIN

Returns the minimum value in a list of arguments

=MIN(number1 [, number2, …])

MINA

Returns the smallest value in a list of arguments, including numbers, text, and logical values

=MINA(number1 [, number2, …])

STDEV

Estimates standard deviation based on a sample

=STDEV(number1 [, number2, …])

STDEVA

Estimates standard deviation based on a sample, including numbers, text, and logical values

=STDEVA(number1 [, number2, …])

STDEVP

Calculates standard deviation based on the entire population

=STDEVP(number1 [, number2, …])

STDEVPA

Calculates standard deviation based on the entire population, including numbers, text, and logical values

=STDEVPA(number1 [, number2, …])

VAR

Estimates variance based on a sample

=VAR(number1 [, number2, …])

VARA

Estimates variance based on a sample, including numbers, text, and logical values

=VARA(number1 [, number2, …])

VARP

Calculates variance based on the entire population

=VARP(number1 [, number2, …])

VARPA

Calculates variance based on the entire population, including numbers, text, and logical values

=VARPA(number1 [, number2, …])

Name

Description

Syntax

CODE

Returns a numeric code for the first character in a text string

=CODE(text)

CONCATENATE

Joins several text items into one text item

=CONCATENATE(text1 [, text2, …])

FIND

Finds one text value within another (case-sensitive)

=FIND(find_text, within_text [, start_num])

LEFT

Returns the leftmost characters from a text value

=LEFT(text[, num_chars])

LEN

Returns the number of characters in a text string

=LEN(text)

LOWER

Converts text to lowercase

=LOWER(text)

MID

Returns a specific number of characters from a text string starting at the position you specify

=MID(text, start_num, num_chars)

PROPER

Capitalizes the first letter in each word of a text value

=PROPER(text)

REPLACE

Replaces characters within text

=REPLACE(old_text, stat_num, num_chars, new_text)

REPT

Repeats text a given number of times

=REPT(trext, number_times)

RIGHT

Returns the rightmost characters from a text value

=RIGHT(text[, num_chars])

SEARCH

Finds one text value within another (not case-sensitive)

=SEARCH(find_text, within_text[, start_num])

SUBSTITUTE

Substitutes new text for old text in a text string

=SUBSTITUTE(text, old_text, new_text[, instance_num])

T

Converts its arguments to text

=T(value)

TEXT

Formats a number and converts it to text

=TEXT(value, format_text)

TRIM

Removes spaces from text

=TRIM(text)

UPPER

Converts text to uppercase

=UPPER(text)

VALUE

Converts a text argument to a number

=VALUE(text)