Calculating percentages based on a single cell

[Guest]

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.

 

[Niek Otten]

Use $A$20 instead of A20

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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.

 

[David Biddulph]

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