Scribd
Upload
7 views5 pages

MS Excel Formulas

The document provides an overview of various MS Excel formulas including SUM, AVERAGE, MAX, MIN, COUNT, COUNTA, IF, CONCATENATE, TODAY, and ROUND. Each formula includes its purpose, syntax, an example, and a solution/result demonstrating its use. These formulas are essential for performing calculations and data manipulation in Excel.

Uploaded by

Iqra Basheer
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
7 views5 pages

MS Excel Formulas

The document provides an overview of various MS Excel formulas including SUM, AVERAGE, MAX, MIN, COUNT, COUNTA, IF, CONCATENATE, TODAY, and ROUND. Each formula includes its purpose, syntax, an example, and a solution/result demonstrating its use. These formulas are essential for performing calculations and data manipulation in Excel.

Uploaded by

Iqra Basheer
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

MS Excel Formulas – Notes & Solutions

1. SUM Formula
Purpose: Adds a range of numbers.

Syntax:

=SUM(number1, number2, …)

Example:

A B

10 20

30 40

Formula: =SUM(A1:B2)
Solution/Result: 10 + 20 + 30 + 40 = 100

2. AVERAGE Formula
Purpose: Calculates the mean of a range of numbers.

Syntax:

=AVERAGE(number1, number2, …)

Example:

10

20

30

Formula: =AVERAGE(A1:A3)
Solution/Result: (10 + 20 + 30)/3 = 20
3. MAX Formula
Purpose: Returns the largest number in a range.

Syntax:

=MAX(number1, number2, …)

Example:

50

70

40

Formula: =MAX(A1:A3)
Solution/Result: 70

4. MIN Formula
Purpose: Returns the smallest number in a range.

Syntax:

=MIN(number1, number2, …)

Example:

50

70

40
Formula: =MIN(A1:A3)
Solution/Result: 40

5. COUNT Formula
Purpose: Counts the number of numeric entries in a range.

Syntax:

=COUNT(value1, value2, …)

Example:

10

Text

20

Formula: =COUNT(A1:A3)
Solution/Result: 2 (counts only numbers)

6. COUNTA Formula
Purpose: Counts all non-empty cells (numbers and text).

Syntax:

=COUNTA(value1, value2, …)

Example:

10

Text
A

20

Formula: =COUNTA(A1:A3)
Solution/Result: 3

7. IF Formula
Purpose: Returns a value based on a condition.

Syntax:

=IF(condition, value_if_true, value_if_false)

Example:

75

Formula: =IF(A1>=50,"Pass","Fail")
Solution/Result: Pass (because 75 ≥ 50)

8. CONCATENATE (or CONCAT) Formula


Purpose: Combines text from multiple cells.

Syntax:

=CONCAT(A1, " ", B1)

Example:

A B

John Doe
Formula: =CONCAT(A1," ",B1)
Solution/Result: John Doe

9. TODAY Formula
Purpose: Returns the current date.

Syntax:

=TODAY()

Solution/Result: 29-01-2026 (changes to current date automatically)

10. ROUND Formula


Purpose: Rounds a number to a specified number of digits.

Syntax:

=ROUND(number, num_digits)

Example:

3.14159

Formula: =ROUND(A1,2)
Solution/Result: 3.14

You might also like