Basic Formulas & Functions in Excel – Complete Guide

Formulas and Functions are the true power of Excel. From simple arithmetic to advanced lookups, they help you perform calculations, analyze data and automate repetitive tasks. If you are new to Excel, learning the basic formulas and functions will give you a solid foundation to handle everyday tasks. Whether you’re adding numbers, searching values, or creating logical tests, mastering formulas & functions will make your Excel work faster and smarter.

This guide gives you a complete overview of Basic formulas & functions in Excel. Bookmark this page—this will be your go-to hub for everything related to Excel calculations.

In this guide, we’ll cover:

  • What are formulas and functions?
  • Difference between formula and function
  • How to write formulas and functions in Excel
  • Commonly used Excel formulas and functions
  • Tips and best practices

What is a Formula in Excel?

A formula is an expression written by you using numbers, cell references, and operators.

  • Example: =A1+B1 → adds the values in A1 and B1.

What is a Function in Excel?

A function is a predefined formula built into Excel. It saves time by performing common calculations automatically.

  • Example: =SUM(A1:A10) → adds all values from A1 to A10.

Difference Between Formulas & Functions:

FeatureFormulaFunction
DefinitionWritten manually using operatorsPredefined calculation provided by Excel
Example=A1+B1-C1=SUM(A1:A10)                    
FlexibilityFully customizable                     Limited to available functions      

How to Write a Formula in Excel?

  1. Start with `=` (equals sign).
  2. Use cell references and operators. Example: `=A1*B1`
  3. Press Enter.

How to Use a Function in Excel

  • Start with `=`.
  • Type the function name.
  • Add arguments inside brackets. Example: =AVERAGE(A1:A10)

In this guide, we’ll explore the most commonly used basic formulas and functions in Excel with simple examples.

Basic Formulas & Functions in Excel:

Here we have 5 cells, now we will perform below tasks with this example.

A1B1C1D1E1
155421
TaskFormula MethodFunction Method
Addition (Sum of all cells) – Add A1 to E1=A1+B1+C1+D1+E1

Answer → 27
=SUM(A1:E1)

Answer →  27
Subtraction

(Subtraction of all 5 cells)
=A1-B1-C1-D1-E1

Answer →  3
=A1-SUM(B1:E1)

Answer →  3
Multiplication (Product of all cells)   Multiply A1 to E1=A1*B1*C1*D1*E1

Answer →  600
=PRODUCT(A1:E1)

Answer →  600
Division (A1 ÷ B1) – Divide first cell by second=A1/B1

Answer →  3
=QUOTIENT(A1,B1)

Answer →  3
Average (Mean of 5 cells)   Find average of all cell values=(A1+B1+C1+D1+E1)/5

Answer →  5.4
=AVERAGE(A1:E1)

Answer →  5.4
Percentage (B1 ÷ A1 in %)=B1/A1

Now go to Home tab on the ribbon and click on percent style option in the number group. Now the percentage style will be displayed.

Answer →  33%
No direct Function.
Maximum (Largest value)   Highest number in the cell rangeNo formula=MAX(A1:E1)

Answer →  15
Minimum (Smallest value)

Lowest number in the cell range
No formula=MIN(A1:E1)


Answer →  1
Count (Number of cells with values)=1+1+1+1+1 (manual count)=COUNT(A1:E1)

Answer →  5

Count Non-Empty Cells

Need to calculate manually=COUNTA(A1:E1)
 
Answer →  5

Current Date

 
Need to enter manually=TODAY()
 
Answer →  
10-09-2025
Current Date & TimeNeed to enter manually=NOW()
 
Answer →  
10-09-2025 10:59
Round (Round A1/B1 result)No formula=ROUND(A1/B1,0)

Answer →  3
Round Up (Always higher)No formula=ROUNDUP(A1/B1,0)

Answer →  3
Round Down (Always lower)No formula=ROUNDDOWN(A1/B1,0)

Answer →  3
Square Root (√A1) – Square root of first cell=A1^0.5  or =A1^(1/2)

Answer →  3.87
=SQRT(A1)

Answer →  3.87
Power (A1 raised to 3)=A1^3

Answer →  3375
=POWER(A1,3)

Answer →  3375
Square (A1 × A1)=A1*A1

Answer →  225
=POWER(A1,2)

Answer →  225
Even
(Next even of A1)
No formula=EVEN(A1)

Answer →  16
Odd (Next odd of A1)No formula =ODD(A1)

Answer →  5

These basic Excel formulas and functions are the foundation of everything you will do in Excel. They help you perform calculations, manage text and handle dates quickly and easily.

By practicing these basic Excel formulas and functions, you can quickly improve your productivity in Excel. Once you are comfortable with these basics, you can move on to more advanced Excel functions for deeper analysis.