Meaning of $ in function or formula

K

Kula

I need an explanation of having to use $ sign in a worksheet funtion.

Thanks in advance for explanation.

Kula
 
D

Dennis

The dollar means that the letter or number after it is an absolute reference
and does not change if rows or columns are inserted or deleted.
 

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

Stop cell changing 3
Using multiple Lookup Functions 1
What is this function? { } 0
Need help with SUMIFs 2
Microsoft 365 Activations, Users or Devices? 0
HLOOKUP, LOOKUP & MATCH doesn't work. Seems not right. 1
CONVERT function for Excel 2003 2
sumproduct 1

Top