Dear All, We use $ sign in formula to relative or absolute reference of the range.
And we use $ sign if we want to show the the amount in dollar rate. On Jan 30, 1:10 am, Paul Schreiner <schreiner_p...@att.net> wrote: > I'm assuming you mean in a Cell formula. > > the $ is an "anchor". > > Let's say you have a column of numbers in column "A" > rows 2-10. > In row 1 you have different numbers in column "B" through "E" > so it looks like: > X 1 2 3 > 1 > 2 > 3 > Now, in the rest of the rows and columns > you want to multiply the value in column "A" > with the value in row 1. > so in cell B2 you use: > =A2*B1 > now you copy this cell to the rest of the cells and > it DOESN'T WORK! > the Cell in C2 is: > =B2*C1 when you WANTED =A2*C1 > and in cell C3 it's: > =B3*C2 when you wanted: =A3*C1 > > so... you need a way to tell excel to NOT change Column "A" > in the first cell reference, and not change the ROW (1) in > the second Cell reference. > > To do that, you tell excel to "anchor" the "A" column > by using $A and "anchor" the row by using $1 > > the formula in B2 is then: > =$A2*B$1 > > Now, when you copy the cell formulas, the A stays the same, > but the row changes.. > > This is actually referred to as using ABSOLUTE references > and Relative references. > > the $A is the ABSOLUTE column A. > so when you copy it, it remains "A" > but for "B", well, the current cell is column "B", > so when you copy it to column C, the formula changes > to "C".. > > does that help? > > Paul > > ________________________________ > From: D M Sukumar <vijayajith...@gmail.com> > To: excel-macros@googlegroups.com > Sent: Sat, January 29, 2011 12:33:37 PM > Subject: RE: $$Excel-Macros$$ Please help > > > Hai groups, > > Can you tell me what is the use of $ sign excel;;;; > And can you give some examples please;;; > Thank you > From:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On > Behalf Of ashish koul > > 1. Follow us on TWITTER for tips tricks and links > :http://twitter.com/exceldailytip > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below > linkhttp://www.facebook.com/discussexcel > > -- > Regards > > Ashish Koul > akoul.blogspot.com > akoul.wordpress.com > My Linkedin Profile > > PBefore printing, think about the environment. > > > -- > ---------------------------------------------------------------------------------- > > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links > :http://twitter.com/exceldailytip > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below > linkhttp://www.facebook.com/discussexcel-- > ---------------------------------------------------------------------------------- > > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links > :http://twitter.com/exceldailytip > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below > linkhttp://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
