I have 4 values of X and 4 values of Y, using these values of X and Y, single value Z has been calculated in Column C with the help of formula. Now I want to maximize Z value in column C using solver. How to select for multiple column?
I have attached excel file and there is an image of formula for calculating Z or r, as I am unable to write that formula in excel. We have to maximize Z value by changing X and Y value. currently Ihave Z value = 0.852, I have to set value of X and Y such that Z is maximum but less than 1.
The Formula should be like this:
Please have a look at enclosed file: