Functions

Excel has many premade formulas, called functions.

Functions are typed by = and the functions name.

For example =SUM

Once you have typed the function name you need to apply it to a range.

For example =SUM(A1:A5)

The range is always inside of parentheses.

Function

Description

=AND

Returns TRUE or FALSE based on two or more conditions

=AVERAGE

Calculates the average (arithmetic mean)

=AVERAGEIF

Calculates the average of a range based on a TRUE or FALSE condition

=AVERAGEIFS

Calculates the average of a range based on one or more TRUE/FALSE conditions

=CONCAT

Links together the content of multiple cells

=COUNT

Counts cells with numbers in a range

=COUNTA

Counts all cells in a range that has values, both numbers and letters

=COUNTBLANK

Counts blank cells in a range

=COUNTIF

Counts cells as specified

=COUNTIFS

Counts cells in a range based on one or more TRUE or FALSE condition

=IF

Returns values based on a TRUE or FALSE condition

=IFS

Returns values based on one or more TRUE or FALSE conditions

=LEFT

Returns values from the left side of a cell

=LOWER

Reformats content to lowercase

=MAX

Returns the highest value in a range

=MEDIAN

Returns the middle value in the data

=MIN

Returns the lowest value in a range

=MODE

Finds the number seen most times. The function always returns a single number

=NPV

The NPV function is used to calculate the Net Present Value (NPV)

=OR

Returns TRUE or FALSE based on two or more conditions

=RAND

Generates a random number

=RIGHT

Returns values from the right side of a cell

=STDEV.P

Calculates the Standard Deviation (Std) for the entire population

=STDEV.S

Calculates the Standard Deviation (Std) for a sample

=SUM

Adds together numbers in a range

=SUMIF

Calculates the sum of values in a range based on a TRUE or FALSE condition

=SUMIFS

Calculates the sum of a range based on one or more TRUE or FALSE condition

=TRIM

Removes irregular spacing, leaving one space between each value

=VLOOKUP

Allows vertical searches for values in a table

=XOR

Returns TRUE or FALSE based on two or more conditions

 


Login
ADS CODE