# simple solver question

#### nelsok

##### Board Regular
I want to maximize k592 by changing cell g592... the data set are fixed values and can not be changed.

The value in g592 is used in the sumif in cells h592 and i592

When I try to use solver to find the max for cell k592 by changing g592 nothing happens... i know that the answer is 10 but if i start solver with a value of 2 in cell g592 the cell does not change to 10.

any ideas on what I am doing wrong?

thanks
Book1.xls
FGHIJK
575ExpenditureRevenueExp / Rev
576\$ 236\$ -1000.00%
577\$ 90\$ -1000.00%
578\$ 5,288\$ 17,2367.00%
579\$ 2,358\$ 6805.00%
580\$ 1,502\$ 49,13510.00%
581\$ 90\$ -1000.00%
582\$ 1,047\$ -1000.00%
583\$ 67\$ -1000.00%
584\$ 1,862\$ -1000.00%
585\$ 928\$ -1000.00%
586\$ 206\$ -1000.00%
587\$ 78\$ -1000.00%
588\$ 651\$ -1000.00%
589Profit
590Total\$ 14,403\$ 67,051\$ 52,647
591
592Optimal %10%\$ 5,255\$ -\$ 5,255
593
594Net\$ 9,148\$ 67,051\$ 57,903
Sheet1

### Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

#### nelsok

##### Board Regular
does anyone who uses solver know why this simple task is failing?

Replies
6
Views
603
Replies
3
Views
359
Replies
1
Views
438
Replies
6
Views
478
Replies
8
Views
194

1,171,205
Messages
5,874,344
Members
433,046
Latest member
aniruddh

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back