Thanks so much FSt1 your explaining ws great it helped me understand it well.
James

"FSt1" skrev:

hi
without the $, you get a relative reference meaning the fomula will adjust
an keep it's references to other cells relative to where you paste it. in
other words, if you have a formula that is add the 2 adjacent cells to the
right, this reference to the e adjacent cells no matter where you paste.
in c1, formula equals =A1+B1
copy and paste at c2. formula now reads =A2+B2
with the $, you get an absolute reference which means the formula will not
adjust and keep the same reference no mater what.
in c1, formula equals =$A$1+B1
copy and paste at c2. formula now reads =$A$1+B2

lookup absolute vs relative references in help for more info

Regards
FSt1
"james" wrote:

When do we use thedollar sign in a formula fro example What is thr difference
between
$H$56 and H56