Scribd
Upload
5K views3 pages

Basic Excel Formulas

The document provides a list of basic Excel formulas along with their functions. It includes operations such as addition, subtraction, multiplication, division, and statistical functions like sum, average, maximum, and minimum. Additionally, it covers logical functions like IF statements and lookup functions like VLOOKUP and HLOOKUP.

Uploaded by

arecharge937
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
5K views3 pages

Basic Excel Formulas

The document provides a list of basic Excel formulas along with their functions. It includes operations such as addition, subtraction, multiplication, division, and statistical functions like sum, average, maximum, and minimum. Additionally, it covers logical functions like IF statements and lookup functions like VLOOKUP and HLOOKUP.

Uploaded by

arecharge937
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
You are on page 1/ 3

Basic Excel Formulas

Addition - =A1+B1

Adds the values in cells A1 and B1.

Subtraction - =A1-B1

Subtracts the value in B1 from A1.

Multiplication - =A1*B1

Multiplies the values in A1 and B1.

Division - =A1/B1

Divides the value in A1 by B1.

Sum - =SUM(A1:A5)

Adds all the values from A1 to A5.

Average - =AVERAGE(A1:A5)

Calculates the average of values from A1 to A5.

Maximum - =MAX(A1:A5)

Returns the highest value in the range A1 to A5.


Basic Excel Formulas

Minimum - =MIN(A1:A5)

Returns the lowest value in the range A1 to A5.

Count - =COUNT(A1:A5)

Counts the number of numeric values in the range A1 to A5.

If Statement - =IF(A1>10,"Yes","No")

Returns 'Yes' if A1 is greater than 10, otherwise 'No'.

Concatenate - =CONCATENATE(A1, " ", B1)

Joins text from A1 and B1 with a space in between.

Today - =TODAY()

Returns the current date.

Now - =NOW()

Returns the current date and time.

VLOOKUP - =VLOOKUP(lookup_value, table_array, col_index, FALSE)

Looks up a value in the first column of a range and returns a value in the same row from another column.
Basic Excel Formulas

HLOOKUP - =HLOOKUP(lookup_value, table_array, row_index, FALSE)

Looks up a value in the first row of a range and returns a value in the same column from another row.

You might also like