Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Help with Excel Formulas?
im trying to create a pricing by multiplier spread sheet.
Column A has the origin numbers. Column B is for the results. So for example =SUM(A6*C4) would be the formula for B6, with C4 being the multiplier i want to change. when i copy the B6 formula into B7, the formula changes to =SUM(A7*C5). i want it to change to A7 but i dont want C4 to change. the idea being that changing the number in C4 changes the pricing for all results columns on the whole spread sheet.
so my question is this. is there a way to copy a formula for all colums with out having to manually change each cell to C4?
2 Answers
- JerryLv 51 decade ago
I have created something myself similar to what you are describing. I ran into the same problem of Excel being too "Intuitive". It is tedious, but go ahead and copy the formulas to where you want and then go back and adjust the multiplier cell identification to the correct cell. I don't know any other way to get the program to do what you want it to do.
