# help with getting cells to move in equivlant values.

1. ## help with getting cells to move in equivlant values.

Hey,

Right.

Im looking at getting Cell A2 (MILES per gallon) to Match Cell B2(COST per gallon.)

So if i MODIFY cell A2, to maybe 90 miles instead of 45, then cell b2 will then change to match that. (in this example it would be 8.14)

then i would have D2 be the value of b2 * c2 (example 4.07 * .45 = 1.83)

So, when ever I modify a2, b2 will change accordingly which will then change the final answer.... to what i want?

heres a picture for reference,,,

Screen Shot 2015-09-25 at 22.35.53.png  Register To Reply

2. ## Re: help with getting cells to move in equivlant values.

Hi, welcome to the forum upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.  Register To Reply

3. ## Re: help with getting cells to move in equivlant values.

I'm not understanding by what you mean by a sample workbook instead of a picture?

The desired outcome would be that the A2 and B2 are linked, which would fit into the rest of my equation.... i have B and C linked so that the answer from there multiplication ends up in D2.

But I need it so that when A2 is changed, B2 is changed automatically in proportion of A2.

Example = A2 = 45 Miles Per Gallon B2 = £4.07 Cost Per Gallon

So is I changed A2 to 90 MPG, then B2 would automatically adjust its self to £8.14

Once it does that, I believe I had D2 already set up to calculate the expenses.  Register To Reply

4. ## Re: help with getting cells to move in equivlant values.

I'm not understanding by what you mean by a sample workbook instead of a picture?
Like I said - not all members can even see your pic
Plus we cannot work with a pic, we need to see a sample workbook   Register To Reply

5. ## Re: help with getting cells to move in equivlant values.

I hope this applies as a samplework book The desired outcome would be that the A2 and B2 are linked, which would fit into the rest of my equation.... i have B and C linked so that the answer from there multiplication ends up in D2.

But I need it so that when A2 is changed, B2 is changed automatically in proportion of A2.

Example = A2 = 45 Miles Per Gallon B2 = £4.07 Cost Per Gallon

So is I changed A2 to 90 MPG, then B2 would automatically adjust its self to £8.14

Once it does that, I believe I had D2 already set up to calculate the expenses.  Register To Reply

6. ## Re: help with getting cells to move in equivlant values.

OK thanks

Try this in B2...=A2/11.0565110565111
11.0565110565111 is based on 45/4.07. If you have a different cost/gallon, then you would need to use that instead  Register To Reply

7. ## Re: help with getting cells to move in equivlant values.

Big thumbs up to you FDibbins.

Solved. Much appreciated... I can finally sleep!  Register To Reply

8. ## Re: help with getting cells to move in equivlant values.

Happy to help, thanks for the feedback   Register To Reply

There are currently 1 users browsing this thread. (0 members and 1 guests) 