Calculating percentages based on a single cell
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. |
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. |
Calculating percentages based on a single cell
"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 |
All times are GMT +1. The time now is 08:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com