Calculating percent off a single cell

D

Dimwit

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!
 
D

David Biddulph

Dimwit said:
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.
Click to expand...

See your other thread.
 
Top