Hello
In a worksheet cell G131 I have this formula
=ROUND(MEDIAN(J131,L131),0)
I want to use solver to change the "J" and "Q" values to find a specific result
eg
if 10 is entered in cell J1 then and 12 is entered in cell K2 then the resulting formula in G131 would be similar to:
=ROUND(MEDIAN(J131,L131),0)
if 2 is entered in cell J1 then and 3 is entered in cell K2 then the resulting formula in G131 would be similar to:
=ROUND(MEDIAN(B131,C131),0)
if 1 is entered in cell J1 then and 2 is entered in cell K2 then the resulting formula in G131 would be similar to:
=ROUND(MEDIAN(A131,B131),0)
In a worksheet cell G131 I have this formula
=ROUND(MEDIAN(J131,L131),0)
I want to use solver to change the "J" and "Q" values to find a specific result
eg
if 10 is entered in cell J1 then and 12 is entered in cell K2 then the resulting formula in G131 would be similar to:
=ROUND(MEDIAN(J131,L131),0)
if 2 is entered in cell J1 then and 3 is entered in cell K2 then the resulting formula in G131 would be similar to:
=ROUND(MEDIAN(B131,C131),0)
if 1 is entered in cell J1 then and 2 is entered in cell K2 then the resulting formula in G131 would be similar to:
=ROUND(MEDIAN(A131,B131),0)
Last edited: