“*”
Used for – “*” Function in MS Excel is used tell MS excel that
a excel has to multiply the cell value (if numbers / fraction) / numbers /
fraction and display the end result achieved.
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
|
Dear readers, after reading the Content please ask for advice and to provide constructive feedback Please Write Relevant Comment with Polite Language.Your comments inspired me to continue blogging. Your opinion much more valuable to me. Thank you.