Mathematical Functions and Text Functions

23/12/2023

These mathematical and text functions in Excel provide users with versatile tools for performing calculations, aggregations, and manipulations on numerical and text data. They are fundamental to creating effective spreadsheets for various purposes, from financial analysis to data organization and presentation.

1. SUM Function:

SUM adds up all the numbers in a range of cells.

Syntax:

=SUM(number1, number2, …)

• number1, number2, …: The numbers to add.

Example:

=SUM(A1:A10)

This formula adds up the values in cells A1 through A10.

1. AVERAGE Function:

AVERAGE calculates the average (arithmetic mean) of a range of numbers.

Syntax:

=AVERAGE(number1, number2, …)

• number1, number2, …: The numbers to average.

Example:

=AVERAGE(B1:B5)

This formula calculates the average of the values in cells B1 through B5.

1. MAX Function:

MAX returns the largest number in a range of cells.

Syntax:

=MAX(number1, number2, …)

• number1, number2, …: The numbers to compare.

Example:

=MAX(C1:C8)

This formula returns the largest value in cells C1 through C8.

1. MIN Function:

MIN returns the smallest number in a range of cells.

Syntax:

=MIN(number1, number2, …)

• number1, number2, …: The numbers to compare.

Example:

=MIN(D1:D6)

This formula returns the smallest value in cells D1 through D6.

Text Functions in Excel:

1. CONCATENATE Function:

CONCATENATE combines multiple text strings into one string.

Syntax:

=CONCATENATE(text1, text2, …)

• text1, text2, …: The text strings to concatenate.

Example:

=CONCATENATE(“Hello”, ” “, “World”)

This formula combines the text strings to create “Hello World”.

1. LEFT Function:

LEFT returns a specified number of characters from the beginning of a text string.

Syntax:

=LEFT(text, num_chars)

• text: The text string.
• num_chars: The number of characters to extract.

Example:

=LEFT(E1, 3)

This formula extracts the first three characters from the text in cell E1.

1. RIGHT Function:

RIGHT returns a specified number of characters from the end of a text string.

Syntax:

=RIGHT(text, num_chars)

• text: The text string.
• num_chars: The number of characters to extract.

Example:

=RIGHT(F1, 4)

This formula extracts the last four characters from the text in cell F1.

1. LEN Function:

LEN returns the number of characters in a text string.

Syntax:

=LEN(text)

• text: The text string.

Example:

=LEN(G1)

This formula returns the number of characters in the text in cell G1.