Thread: Using Excel as variable solver

Will this change the A value so that it will calculate it for the different ones?

repost, disregard.

If you look at the formula I posted in post 6, some of the references had $ in them. The $ tell Excel to make that part of the reference absolute, meaning that it doesn't change with a copy/paste. The reference without the $ will change relative to the cell pasted into. So, the A1 in the formula entered in B1 will change to A2 when pasted in B2 and so on. So, if you've entered all of your y values into column A, copying the formula down in column B should give the value of x corresponding to the y value entered in column A.

Okay, so I attempted to do this, paste:
=(A1-.0313)/67880
all the way down. It gives me the same value in my B column for every A value. It does not seem to change specific to what A column it is entered next to.

Check your calculation options (options dialog) and make sure it is set to automatic.

And, my apologies, but I've got to go. Good luck. When you get this little exercise figured out, you should have a good intro to spreadsheets in general, and Excel specifically.

Okay, I will try and figure it out. If not, I suppose I can change the A value by hand. Thank you so much for helping me figure this out. I am very appreciative.