View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 618
Default 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