What does a $ in an excel formula do?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What does a $ in an excel formula do?
I am using someone else's template and I don't know how to tell what it does.
 
Its called absolute referencing.. =$A$1 dragged down will remain as the
value in A1. =A1 dragged down will become the values in A2, A2, A3 etc. That
is to say the dollar sign 'locks' the cell reference and does not allow it
to be altered by copying, dragging and so on. Check out 'Absolute! in help,
its all there,
Regards,
Alan.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Advanvnce formula and function 1
How to subtract a number from a Mergefield? 0
What does " mean in excel 5
Keep formulas in an Excel template when I delete data 6
How Do I Avoid #REF! In Formulas? 4
Excel functions 0
Workday Formula to include date 0
What does this formula mean [$-F400]h:mm:ssAM/PM 2

Back
Top