Autofill Incorrect Results

[Data123]

Hi I have three cells in one column with formulas shown below.

=((Data!B2-Data!B6)/Data!B6*100)

=((Data!C2-Data!C6)/Data!C6*100)

=((Data!D2-Data!D6)/Data!D6*100)

when I highlight the three cells and use the black cross on the bottom right hand corner of the last cell, the autofill offers this formula for the next cell:

=((Data!B5-Data!B9)/Data!B9*100) which is incorrect.

How can I fix this please?

 

[Joe4]

It would never work for the formula originally posted here, no.

Thanks for confirming!
I have had it happen over the years where I don't think something is possible, and then someone identifies some feature unknown to me or some "trick" to make it work.
Just wanted to make sure I wasn't missing anything!

 

[Data123]

It would never work for the formula originally posted here, no.

would it work if the data is transposed? Joe4 hinted the term here. If autofill would work if data is transposed why is this?

 

[RoryA]

Excel will increment the row numbers based on where the formula is filled to. It's not clear to me what you actually want the result to be in the next row(s). Currently, your first formula is being repeated three rows lower, so all the rows will be incremented by 3.