Forum Discussion
Dragging and copying a formula
Hi, hoping someone can figure this out. I am trying to copy down a % increase - its a long list but it will not copy down. I have gone into automation and that is ticked, also file options advanced and ensured all that is ticked but still nothing it just gives random numbers. Hoping you can help. Thanks
Ensure that the formula you're using to calculate the percentage increase is correct. The formula should reference the appropriate cells for the starting and ending values. For example, if you have the starting value in cell A1 and the ending value in cell B1, the formula for calculating the percentage increase in cell C1 would be: =(B1-A1)/A1.
- What does your formula look like? Can you post a sample workbook with both results and expected outcome?
Thanks for sharing this valueable information. It is very useful information.
<Link Removed by Admin>
