Excel Functions Cheat Sheet PDF: Ultimate List & Examples
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.
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.
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.
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).
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.
Syntax: =AND(logical1, [logical2, ...]), =OR(logical1, [logical2, ...]), =NOT(logical)
Download our comprehensive Excel functions list PDF for even more functions and examples.