formula

[james]

When do we use thedollar sign in a formula fro example What is thr difference
between
$H$5>6 and H5>6

 

[Mike H]

James,

The dollar Fixes the reference and makes it absolute so when its dragged it
doesn't change. You can fix the column

$F4

The row

F$4

or both

$F$4

The easiest way to enter the symbols is by tapping F4 when yoiu enter the
formula in the formula bar.

Mike

 

[FSt1]

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]

Thanks Mike for your help. Its very much appreciated

James

"Mike H" skrev:

 

[james]

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

"FSt1" skrev: