excel functions list pdf

Excel Functions Cheat Sheet PDF: Ultimate List & Examples

By Rachel Jackson
AD

Are you a spreadsheet specialist seeking a comprehensive list of Excel functions? Look no further. This guide presents an extensive list of Excel functions, categorized for easy navigation. Though Excel offers over 400 functions, this guide focuses on the most essential and commonly used. Let's dive in.

Basic Arithmetic and Mathematical Functions

The core of Excel operations lies in its mathematical functions. These functions perform essential calculations with large datasets accurately and swiftly.

Addition Functions

SUM, SUBTOTAL, and AVERAGE are Excel's primary addition functions. SUM adds values together, while SUBTOTAL includes or excludes subtotals based on a specified option. AVERAGE calculates the mean of a set of values.

AD
Excel Formulas Cheat Sheet | 50+ Essential Excel Functions for Beginners
Excel Formulas Cheat Sheet | 50+ Essential Excel Functions for Beginners
the 50 essential functions excel chart
the 50 essential functions excel chart
350 Excel Functions Every Data Analyst Uses
350 Excel Functions Every Data Analyst Uses

Syntax: =SUM(number1, number2, ...)

Subtraction, Multiplication, and Division Functions

DIVIDE, Multiply, and Stereo perform subtraction, multiplication, and division respectively. SUBTOTAL can also perform subtraction based on specified options.

a green and white flyer with instructions for functions in excel, word or text on it
a green and white flyer with instructions for functions in excel, word or text on it
the excel formulas chart with numbers and symbols for each item in this table, you can
the excel formulas chart with numbers and symbols for each item in this table, you can
the excel format sheet is shown with instructions for each item in this document, and also includes
the excel format sheet is shown with instructions for each item in this document, and also includes

Syntax: =DIVIDE(number, divisor), =MULTIPLY(number1, number2), etc.

Logical and Informational Functions

Excel also offers functions that provide information and make logical decisions based on specified conditions.

AD

IF and ELSE functions

IF and ELSE work together to test a condition and return specific results based on true or false responses. The syntax is =IF(logical_test, value_if_true, value_if_false).

Excel Text Functions Cheat Sheet: 16 Essential Formulas Every Analyst Should Know
Excel Text Functions Cheat Sheet: 16 Essential Formulas Every Analyst Should Know
Top 21 Excel Formulas
Top 21 Excel Formulas
an excel function sheet with the numbers and symbols for each item in it, including
an excel function sheet with the numbers and symbols for each item in it, including
COUNTIFS Function in Excel
COUNTIFS Function in Excel
Part 15
Part 15
a poster with the words and numbers for formulas in excel, as well as an image
a poster with the words and numbers for formulas in excel, as well as an image

Example: =IF(B2>0, "Positive", "Non-positive")

AND, OR, and NOT functions

AND, OR, and NOT are logical operators that evaluate multiple logical expressions. AND and OR return TRUE or FALSE based on the conditions supplied, while NOT negates a logical expression.

AD

Syntax: =AND(logical1, [logical2, ...]), =OR(logical1, [logical2, ...]), =NOT(logical)

Download our comprehensive Excel functions list PDF for even more functions and examples.
AD