| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating from last inputted cell | New Users to Excel | |||
| How to copy single cell into cell that is merged from two cells? | Excel Discussion (Misc queries) | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
