Thursday, June 13, 2013
Excel-ன் அடிப்படை பார்முலாக்கள்
கீழே உள்ள எக்சல் கால்குலேசனுக்கு எப்படி பார்முலாக்கள் அமைக்கலாம் என்பதின் மூலம் அடிப்படை பார்முலாக்களின் பயன்பாட்டை தெரிந்து கொள்ளலாம்..
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.
|
