Calculating percent off a single cell
 

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!

Calculating percent off a single cell
 

"Dimwit" wrote in message
...
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.
--
David Biddulph