Dragging and copying a formula

Question

Hi, hoping someone can figure this out.&nbsp; I am trying to copy down a % increase - its a long list but it will not copy down.&nbsp; 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.&nbsp; Hoping you can help.&nbsp; Thanks&nbsp;

pinky1635 · Answer

Thank youJKPieterse&nbsp;I have just worked it out, I really appreciate you coming back to me.&nbsp;&nbsp;Thank you

arineplain · Answer

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.

snake game

jkpieterse · Answer

What does your formula look like? Can you post a sample workbook with both results and expected outcome?

blogulluigian · Answer

Thanks for sharing this valueable information. It is very useful information.&lt;Link Removed by Admin&gt;

Forum Discussion

Dragging and copying a formula

Share

Resources