Forum Discussion

Pinky1635's avatar
Pinky1635
Copper Contributor
Dec 05, 2023

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

 

Formulas and Functions

5 Replies

  • dhaval109D's avatar
    dhaval109D
    Copper Contributor
    May 27, 2026

    I like how this highlights that Excel isn’t just copying formulas blindly—it’s interpreting intent through relative positioning. The distinction between copying, dragging, and locking references with F4 is something that’s easy to overlook but makes a big difference in real usage.

     

    https://superchess.iamraj.dev

  • blogulluigian's avatar
    blogulluigian
    Copper Contributor
    Aug 17, 2024

    Thanks for sharing this valueable information. It is very useful information.

    <Link Removed by Admin>

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Dec 05, 2023
    What does your formula look like? Can you post a sample workbook with both results and expected outcome?
    • Pinky1635's avatar
      Pinky1635
      Copper Contributor
      Dec 05, 2023

      Thank youJKPieterse 

      I have just worked it out, I really appreciate you coming back to me.  

      Thank you

  • arineplain's avatar
    arineplain
    Copper Contributor
    Dec 05, 2023

    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.

     

     

    https://snake-game.io