“$”
Used for –
“$” Function in MS Excel is used tell MS excel that a cell / row / column has been fixed for reference
in a formula throughout the sheet in which the formula has been written.
Syntax –
“$” is syntax in itself i.e. no syntax is used for it.
Example – Suppose
you have to multiply value of cell B3 to B1000 and C3 to AAZ3 with cell A1 and want the result in A3 to A1000 and C2 to AAZ2, then you have choice either multiply one by one or you just write =$A$1*B3 in cell A3 and then drag the same upto A1000 and copy the formula and paste the same in the C2 to AAZ2.See example
below:-
A
|
B
|
C
|
D
|
E
|
F
|
G
|
H
|
I
|
|
1
|
20
|
||||||||
2
|
=$A$1*C3
|
=$A$1*D3
|
=$A$1*E3
|
=$A$1*F3
|
=$A$1*G3
|
=$A$1*H3
|
=$A$1*I3
|
||
3
|
=$A$1*B3
|
1
|
2
|
3
|
4
|
5
|
6
|
7
|
8
|
4
|
=$A$1*B4
|
2
|
|||||||
5
|
=$A$1*B5
|
3
|
|||||||
6
|
=$A$1*B6
|
4
|
|||||||
7
|
=$A$1*B7
|
5
|
And
result you get as under:-
A
|
B
|
C
|
D
|
E
|
F
|
G
|
H
|
I
|
|
1
|
20
|
||||||||
2
|
40
|
60
|
80
|
100
|
120
|
140
|
160
|
||
3
|
20
|
1
|
2
|
3
|
4
|
5
|
6
|
7
|
8
|
4
|
40
|
2
|
|||||||
5
|
60
|
3
|
|||||||
6
|
80
|
4
|
|||||||
7
|
100
|
5
|
You
can check it yourself by copy the highlighted table and pasting in the first
cell of the spread sheet.
