Scribd
Upload
11 views

Excel Functions

Uploaded by

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

Excel Functions

Uploaded by

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

Basic Arithmetic Functions

SUM(cell_range): =SUM(A1:A10) - Adds the values in cells A1 through A10.


AVERAGE(cell_range): =AVERAGE(B1:B10) - Calculates the average of values in cells
B1 through B10.
COUNT(cell_range): =COUNT(C1:C10) - Counts numeric entries in cells C1 through C10.
COUNTA(cell_range): =COUNTA(D1:D10) - Counts all non-empty entries in cells D1
through D10, including text.
MAX(cell_range): =MAX(E1:E10) - Finds the maximum value in cells E1 through E10.
MIN(cell_range): =MIN(F1:F10) - Finds the minimum value in cells F1 through F10.
Round Functions
ROUND(value, number_digit): =ROUND(12.3456, 2) - Rounds 12.3456 to 12.35 (2 decimal
places).
ROUNDUP(value, number_digit): =ROUNDUP(12.3456, 1) - Rounds 12.3456 up to 12.4 (1
decimal place).
ROUNDDOWN(value, number_digit): =ROUNDDOWN(12.3456, 1) - Rounds 12.3456 down to
12.3 (1 decimal place).
Logical Functions
IF(logical_test, if_true, if_false): =IF(A1>50, "Pass", "Fail") - Returns "Pass" if
the value in A1 is greater than 50, otherwise "Fail".
AND(logical_test_1, logical_test_2, …): =AND(A1>10, B1<20) - Returns TRUE if A1 is
greater than 10 and B1 is less than 20.
OR(logical_test_1, logical_test_2, …): =OR(A1>50, B1<30) - Returns TRUE if A1 is
greater than 50 or B1 is less than 30.
Arithmetic Functions with Conditions
COUNTIF(range, criteria): =COUNTIF(A1:A10, ">50") - Counts how many cells in A1
through A10 have values greater than 50.
SUMIF(range, criteria, sum_range): =SUMIF(B1:B10, ">50", C1:C10) - Sums the values
in C1 through C10 where corresponding B1 through B10 values are greater than 50.
AVERAGEIF(range, criteria, sum_range): =AVERAGEIF(D1:D10, ">=70", E1:E10) -
Averages the values in E1 through E10 where corresponding D1 through D10 values are
70 or greater.
Lookup Function
VLOOKUP(lookup_value, table_array, column_index, range_lookup): =VLOOKUP(101,
A1:C10, 2, FALSE) - Searches for 101 in the first column of the range A1:C10 and
returns the value from the second column in the same row.

You might also like