Solver or other function

[sarahqputra]

Dear All,

I need help to find the average of a range
i try to use solver in excel but no luck

please help me on this

thank you

[Kaper]

To use solver you have to define goal function which depends on same changed variables.

As your goal is to have average price equal 1 mill you shall have a cell with a function where this average is calculetaed. Let's use for this cell D7 as in your example and write there approppriate formula:

Please Login or Register  to view this content.

of course while prices are ? it show error but once there will be numbers in D2:D6 it will work fine

How these numbers shall be calculated - if you want to have the price growning with decreasing supply you can do this by having a formula which relates price with inversed supply.
simple form would be for instance:

Please Login or Register  to view this content.

let's assume that base price is 0.5 mill and your price_increase_for_low_supply_factor will be stored in a cell C9 (write there some value - say 0 for the start)
then in D2 you can write:

Please Login or Register  to view this content.

and copy down - as you see all prices are at the moment 0.5 mill because the influence of short supply is 0

But we had set up the scenes for solver - use it - your D7 is a goal. you want there value of 1 mill changing cell(s) C9.
Run solver and see proposed prices. It you are happu with that - perfect if not - experiment with other base prices or modifications of the formula to suit your taste.

[sarahqputra]

thank you for your help kaper, any other experiment modification function from anyone? please share... thanks again

[Kaper]

another proposition - cell D2 and copy down:

Please Login or Register  to view this content.

and run solver again
Yet another

Please Login or Register  to view this content.

etc.

[sarahqputra]

thanks again kaper, i just put this on solve.