"Dimwit" wrote in message
...
I'm claculating percents of gross sales, and I want to be able to create a
column which takes the value of all the cells in my P&L and divides them
by
gross sales. For example: (x/y), (x+1)/y, (x+2)/y, etc. When I try and
copy the original formula, I get x/y, (x+1)/(y+1), (x+2)/(y+2), etc.
Where
y=gross sales, I want the denominator to remain a constant reference to a
given cell. I know it's got to be an easy fix, I just can't find it
anywhere.

Look up absolute & relative references in Help
--
David Biddulph