Andrew has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course
Access Advanced course
Absolute values
how do i use absolute values in a formula
RE: absolute values
Hi Andrew
Lets say your formula was =A1/B1
and you wanted the A1 to be absolute but the denominator cell to be variable, you would place dollar symbols as follows =$A$1/B1