| Post ID |
Timestamp |
Content |
User |
| 410544 |
2005-12-06 06:17:00 |
I wish to create a simple worksheet that calculates a percentage from two given values eg 14/16. I want the cell into which the percentage goes to apply that calcuation to subsequent cells.eg If the percentage is calculated from C1/D1*100, I want it to apply to C2/D2, C3/D3 and so on. How do I get it to do that?
Thanks :) |
smurf (6545) |
| 410545 |
2005-12-06 06:54:00 |
If you have got your formula correct for the 1st two cells then hover your cursor over the bottom right hand corner of the cell containing the formula. The cursor will change to a +, then pull your mouse down the page, this will highlight the cells you select and fill them with the contents of the cell you have dragged. In your case the formula. |
EX-WESTY (221) |
| 410546 |
2005-12-06 06:58:00 |
Thank you Westy. I will try that. |
smurf (6545) |
| 410547 |
2005-12-06 07:29:00 |
A suggestion for your formula - don't multiply by 100. Format the cell as % instead. |
wotz (335) |
| 410548 |
2005-12-06 17:08:00 |
Thank you Wotz |
smurf (6545) |
| 1 |
|