Forum Discussion
problem with solver in excel
I have 200 columns and it's total in last column. I want to change my total so it will automatically changes the value with its ratio.
Example
| Columns | Value |
| A | 10 |
| B | 20 |
| C | 3 |
| D | 0 |
| E | 50 |
| F | 28 |
| G | 27 |
| H | 38 |
| I | 90 |
| J | 107 |
| Total | 373 |
I want change the total to 400 how to do in Excel . I have tried to use solver but it's giving the error message. is there other way to do . i have several rows . I don't want to do manual work. kindly help.
Thanks in Advance
8 Replies
If you mean that you want to restate the values for A to J so that the sum becomes 400, but keeping the same ratio as originally, the formulae in the attached workbook (column C) may offer you a solution.
Riny_van_Eekelen thank you for your reply. I have 200+ columns and several rows, this is manual exercise . I want to see some different option like solver where I can change total pressing the button It will change all columns amount.
This is the last option I will use.
I think you need to upload your actual spreadsheet, or else a more accurate representation of it. You say you have "200+ columns and several rows," but the example you gave shows only one column with more than several rows. So @Riny_van_Eekelen gave you a reasonable answer to what was an ambiguous question.
For what it's worth, Solver is really powerful, but also well known to be very difficult to master, so it's not at all surprising that you might get an error message. I have a recent edition of the Excel Bible 2019, and the authors make a point of underscoring how complex that particular Add-In product is. It makes it doubly difficult then when your description of the situation is ambiguous. So if it's possible to upload your original workbook/spreadsheet and give a clearer description of what you're trying to do, that would help us help you.
