Functions in Excel

i. UPPER

The upper function is used to convert a text into uppercase. =Upper (“trincomalee”) will give you TRINCOMALEE

ii. LOWER

Converts all uppercase letters in a text string to lowercase. =Lower (“CHINTHAKA”) will give you chinthaka

iii. PROPER

Capitalizes the first letter in a text string and any other letters in text that follow any character other than a letter. Converts all other letters to lowercase letters. =Proper (“online it academy”) will give you Online It Academy

iv. TRIM

Removes the unnecessary spaces from a string =Trim (“Online It Academy”) → Online It Academy

v. REPT

Repeat a text a given number of times. =REPT (“@ # %”, 20)

vi. SQRT

Returns a positive square root. = sqrt (81) → 9

vii. ROUND

Rounds a number to a specified number of digits. =Round (2.5678,2) → 2.57

viii. POWER

Returns the result of a number raised to a power. = Power (7,3) → 343

ix. MOD

Returns the remainder after a number is divided by another number. = mod(17,6) → 5

x. INT

Returns the integer value after a number is divided by another number. =Int(10/3) → 3

xi. POWER

Returns the result of a number raised to a power. =Power(5,3) → 125

xii. SUM

Adds all the numbers in a range of cells. = Sum(12,5,7) → 24 = Sum (A1 : A5)

xiii. AVERAGE

Returns the average (arithmetic mean) of the arguments. = Avg (3,4,5) → 4 = Average (A1: A5)

xiv. MAX

Returns the largest value in a set of values. = Max (12,45,6,67,82,11) → 82 = Max (A1: A5)

xv. MIN

Returns the smallest value in a set of values. = Max (12,45,6,67,82,11) → 6 = Max (A1: A5

Posted in: Excel