I have a min / max and average, and the average is (min + max) / 2.

So for eg



I then want to reduce the average by 5%, but hold the maximum, thus by only changing the minimum.

Thus what is the formula needed to work this out? Its in Excel if that helps, I think my brain is fried, as I am sure its simple!!

Thanks y'all

calculate what 5% of the average would be and then take twice as much off the min figure.

What Hyperlink said. It's *not* ten percent off the minimum.

Yes, but my average is a live cell and its only my min and max I have as numbers, the ave is a calculation, so I am thinking there must be a way to state a formula based on the minimum.

For e.g.



Or am I trying to hard and should just take the easy route above, which to be fair is what I had?!

New Avg = Old Avg * (1 - 5%)

and

New Min = Max - (Max - New Avg) * 2

or

New Min = New Avg - (Max - New Avg)

and both of these can be expressed alternately as

New Min = 2 * Old Avg * (1 - 5%) - Max

Not sure where the banana fits in?

A1 =60
A2 =100
A3 =average(A1:A2) ....80
A4 =average((A1-0.05*A3*2),A2)