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