what it mean by (=$AB$35 )
 

i would like to know the function of $ in Excel

what it mean by (=$AB$35 )
 

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

what it mean by (=$AB$35 )
 

Just to follow on Max's reply, to toggle between the different states, you
can simply press F4.

Rgds,
mwl

"Max" wrote:

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

what it mean by (=$AB$35 )
 

Cool tip! Thanks for sharing it!
--

Chuck M.


"mwl" wrote:

Just to follow on Max's reply, to toggle between the different states, you
can simply press F4.

Rgds,
mwl

"Max" wrote:

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