$

$

“$”


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.
""

""

Used for – “” Function in MS Excel is used so that MS excel can read text in any one of its formula.

Syntax – “text” – here you have to replace text with the text you want to mention in the formula.

Example – Suppose you have written 1in cell A1 and 2 in cell A2 and you want 1.2 result by combining cell A1 and Cell A2 in cell A3 then just type A1&”.”&A2 in cell A3 and you got the result.

Similarly, you wrote Ankit in cell A1 and Kalra in cell A2 and you want Ankit Kalra result by combining cell A1 and cell A2 in cell A3 then just type A1&” “&A2 in cell A3 and you got the result.

'

'

Used for – ‘ Function in MS Excel is used to convert number into text so that MS excel read number as text.

Syntax – ‘ is syntax in itself i.e. no syntax is used for it.


Example – Suppose you want to write 001 in a cell but it automatically change to 1 then simply write’001 in a cell and excel will read it as text and displays as 001.
&

&

“&


Used for – “&” Function in MS Excel is used for combining two or more values/text/alphanumeric of two cell to make it as single.

Syntax – “&” is syntax in itself i.e. no syntax is used for it.

Example – Suppose you have written 1in cell A1 and 2 in cell A2 and you want 12 result by combining cell A1 and Cell A2 in cell A3 then just type A1&A2 in cell A3 and you got the result.
Similarly, you wrote Ankit in cell A1 and Kalra in cell A2 and you want AnkitKalra result by combining cell A1 and cell A2 in cell A3 then just type A1&A2 in cell A3 and you got the result.

More use of & is explain in example of  “”.
Ask .........

Ask .........

No Comments
Please Quote your query in detail and i will reply asap.......
Asking is a good habit, so don't be hesitate to query what you want to do with excel with detail description of your query and available data. 

It's Excel ---->>>Its' easy......

No Comments

News

News

 Launching Shortly


Chapter 3 :- Use of Simple Formula

Chapter 3 is now partially available !!!!!!!! 

Is this article helpful to you?

Amazon