Scribd
Upload
6 views1 page

Essential Excel Functions Guide

Uploaded by

diyariju065
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
6 views1 page

Essential Excel Functions Guide

Uploaded by

diyariju065
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

Function Operation

Adds all the numbers in a range of cells


SUM
=SUM(A1:A10)

Calculates the average of a range of cells


AVERAGE
=AVERAGE(A1:A10)

Finds the largest and smallest numbers in a range respectively

MAX and MIN =MAX(A1:A10)

=MIN(A1:A10)

Rounds a number down to the nearest integer


INT
=INT(A1)

Rounds a number to a specified number of digits


ROUND
=ROUND(A1,2) - round to 2 decimal places

Counts the number of cells in a range that contain numbers


COUNT
=COUNT(A1:A10)

Counts the number of cells in a range that contain numbers and/or labels
COUNTA
=COUNTA(A1:A10)

Returns one value if a condition is true and another if it's false

IF =IF(condition, true, false)

=IF(A1 ="SME",100,B7*3)

Performs a horizontal look up of data


HLOOKUP
=HLOOKUP('Bananas', A2:D4, 3)

Performs a vertical look up of data


VLOOKUP
=VLOOKUP(100, A2:D4, 2, TRUE)

Performs either a horizontal or vertical look up of data


XLOOKUP
=XLOOKUP('Oranges', A1:A4, Sales Q3, "Not found")

You might also like