Tuesday, September 7, 2010

எக்சலின் அடிப்படை பார்முலாக்கள்



உதாரணமாக ஒரு எக்சல் கால்குலேசனை எடுத்துகொள்வோம்.



SAMPLE FORMULAS:
Type of Equation:
Entered in Cell D3:
Result Displayed in D3:
Addition of Two Cells
= A2 + B3
46
Addition of a Constant
= B1 + 25
53
Addition of a Row of Cells
= SUM (A1:C1)
148
Addition of a Column of Cells
= SUM (B1:B3)
123
Addition of a Range of Cells
= SUM (B1:C3)
237
Addition of Scattered Cells
= SUM (A2,B1,C3)
75
Subtraction of a Constant
= C1 – 10
85
Subtraction of a Cell
= B2 – B1
63
Multiplication by a Constant
= A3 * 20
60
Multiplication of Two Cells
= B3 * C3
20
Multiplication by a %
= A1 * .40
10
Multiplication by a %
= B1 * 25%
7
Division by a Constant
= C1 / 5
19
Division by a Cell
= A2 / C2
3
Exponentiation (Squaring)
= B3 ^ 2
16
Exponentiation (Cubing)
= A3 ^ 3
27
Square Roots
=SQRT(A1)
5
Square Roots
= A1 ^ 0.5
5
Cube Roots
= B1 ^ (1/3)
3.036589
Increasing by a Percentage (4%)
= A1 + (A1 * .04)
26
Increasing by a Percentage (4%)
= A1 * 1.04
26
Increasing by a Percentage (4%)
= A1 + (A1 * 4%)
26
Decreasing by a Percentage (8%)
= A1 - (A1 *.08)
23
Decreasing by a Percentage (8%)
= A1 *.92
23
Decreasing by a Percentage (8%)
= A1 – (A1 * 8%)
23
Calculate a Percentage (Part/Sum)
=A3 / $D$3
25% (Format as a %)
Average of a Column
= AVG (B1:B3)
41
Average of a Row
= AVG (A3:C3)
4
Average of a Range
= AVG (B1:C2)
57
Formula referring to a cell in another worksheet
= Sheet2!C4
The contents of cell C4 in Sheet2

No comments:

Post a Comment