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
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 | ||||||||
---|---|---|---|---|---|---|---|---|
F | G | H | I | J | K | |||
575 | Expenditure | Revenue | Exp / Rev | |||||
576 | $ 236 | $ - | 1000.00% | |||||
577 | $ 90 | $ - | 1000.00% | |||||
578 | $ 5,288 | $ 17,236 | 7.00% | |||||
579 | $ 2,358 | $ 680 | 5.00% | |||||
580 | $ 1,502 | $ 49,135 | 10.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% | |||||
589 | Profit | |||||||
590 | Total | $ 14,403 | $ 67,051 | $ 52,647 | ||||
591 | ||||||||
592 | Optimal % | 10% | $ 5,255 | $ - | $ 5,255 | |||
593 | ||||||||
594 | Net | $ 9,148 | $ 67,051 | $ 57,903 | ||||
Sheet1 |