Calculating percentages based on a single cell
Use $A$20 instead of A20
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"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.
|
| Thanks for your help.
|