1
Excel
Arithmetic
Functions
Sakshi Suhas Masekar NEXT
2
Basic Functions
Overview
Understanding Excel Functions
Excel provides various arithmetic functions such as SUM,
SUBTRACT, MULTIPLICATION, DIVISION, AVERAGE, MIN, and
MAX. These functions allow users to perform basic
calculations easily, streamlining data analysis.
NEXT
Addition How to Add in Excel
• To add numbers in Excel, use the SUM function: =SUM(A1:A5). It adds values from cells A1 through A5,
providing a quick total.
Subtraction Performing Subtraction
• Subtraction is executed using the formula: =A1-A2. This allows you to calculate the difference
between two cell values easily.
Multiplication Multiplying Values
• In Excel, to multiply values, use the formula =A1*A2. This multiplies the values in cells A1 and
A2 and returns the product.
Division Dividing in Excel
• Division is performed with a formula like =A1/A2. This divides the value in cell A1 by the value
in cell A2, providing the quotient.
NEXT
4
NEXT
5
Common Errors
Mistakes to Watch For
Common errors include #DIV/0! when dividing by zero,
#VALUE! for incorrect cell types in operations, and
forgetting to use parentheses, which alters operation order.
NEXT
6
Function Comparison
Function Purpose Example
SUM Adds values =SUM(A1:A10)
AVERAGE Calculates mean =AVERAGE(A1:A10)
MIN Finds minimum value =MIN(A1:A10)
MAX Finds maximum value =MAX(A1:A10)
NEXT
7
Practical Applications
40% 30% 20% 10%
Financial Applications Analyzing Data Generating Reports Managing Inventory
Arithmetic functions are Used frequently in data Helps in summarizing data Arithmetic functions
essential in creating analysis for calculating for reports to present clear maintain accurate records
financial models for averages, totals, and insights. of stock levels and value.
budget analysis and finding trends.
forecasting.
NEXT
