"Kiran" wrote:
i would like to know the function of $ in Excel

The $ sign in eg: $AB$35 makes that cell reference absolute, ie fixed, so
that it won't change when you copy the formula containing: $AB$35 across or
down.

AB is the col ref
35 is the row ref

There are 4 different states for any cell ref:
AB35 - both col & row refs are relative
$AB35 - col is fixed, row is relative
AB$35 - col is relative, row is fixed
$AB$35 - both col & row are fixed

Depending on how you want the col/row refs to change as you copy a formula
across/down, you would use one of the 4 states
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,400 Files:358 Subscribers:55
xdemechanik
---