Calculating percent off a single cell

[Guest]

I exported a P&L from another app and I want to calculate percents of gross
sales. How do I calculate the percentage of all the cells in a column
divided by a single column? Copying the formula (x/y) gives me (x+1/y+1)
where x & y are cell addresses, and I want (x+1/y), (x+2/y) etc.

Thanks!

 

[David Biddulph]

I exported a P&L from another app and I want to calculate percents of gross
sales. How do I calculate the percentage of all the cells in a column
divided by a single column? Copying the formula (x/y) gives me (x+1/y+1)
where x & y are cell addresses, and I want (x+1/y), (x+2/y) etc.

See your other thread.