what it mean by (=$AB$35 )

[Kiran]

i would like to know the function of $ in Excel

 

[Max]

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

 

[mwl]

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

Rgds,
mwl

 

[Chuck M]

Cool tip! Thanks for sharing it!
--

Chuck M.

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

Rgds,
mwl