January 22, 2014

Formulae in Excel

formulae in excel, formulae in excel 2007, formulae in excel 2010, formulae in excel sheet, excel spreadsheet formulas, worksheet function excel, excel sheet formulas with example,excel sheet formulas ,excel sheet formulas list, excel sheet formulas with example, excel sheet formula  



Calculation

Formula

Example

Addition

+
=CR+CR =B2+B3
Sum

sum
=sum(CR:CR) =sum(B2:B15)
Autosum

S
=S(CR:CR) =S(B2:B15)
Subtraction

-
=CR-CR =B2-B1
Multiplication

*
=CR*CR =B5*B18
=B6*10
Division

/
=CR/CR =B5/B18
=B6/10
Average

average
=average(CR:CR) =average(D3:D14)
Percentages

%
=CR*P%

(P = percentage value)
=E4*10%
=E4*17.5%

No comments:
Write comments