Excel Formulas

Top excel formulas & functions

1. CONCATENATE
Formulae: CONCATENATE(text1,text2,…)
Concatenate formulae is used for join several text in different cells.

2.Floor
Formulae: =FLOOR(number,significance)
Rounds a number down, toward zero

3.Exact
Formulae: =EXACT(text1,text2)
Checks to see if two text values are identical

4.LOWER
Formulae: =LOWER(text)
Converts text to lowercase

5.PROPER
Formulae: =PROPER(text)
Capitalizes the first letter in each word of a text value /br>

Excel Basic Math Formulae

Function Formula Example
To add up the total =SUM(cell range) =SUM(B2:B9)
To add individual items =Value1 + Value 2 =B2+C2
Subtract =Value1 - Value 2 =B2-C2
Multiply =Value1 * Value2 =B2*C2
Divide =Value1 / Value2 =B2/C2
Exponents =Value1 ^ Value2 =B2^C2
Average =AVERAGE(cell range) =AVERAGE(B2:B9)
Median =MEDIAN(cell range) =MEDIAN(B2:B9)
Max =MAX(cell range) =MAX(B2:B9)