Conditional Goalseek VBA

[mosen]

Hi Guys,
I'm a beginner excel user try to use it to model semiconductor behaviour. I have a numerical analysis model which starts with an initial value (change cell target) called N_front.
This N_front then will be used to calculate numbers of value for delta_n at different depth (column D23:D423). The goal cell called gen_rec and need to be 0. However, from physical point of view, delta_n values have to be absolutely decreasing D23>D24>D25>...>D423. My question is how to add this condition to be considered in goalseek? I can get the answer (gen_rec = 0) without this condition which is mathematically true but that is not a valid physical answer.
Thanks

 

[JoeMo]

Goal seek allows only a single parameter to be varied in trying to achieve a target value for a variable linked to that parameter.

You can improve your chances of getting some help if you post a sample of your data and explain what you want to do.

 

[pplstuff]

Look into the 'solver' add-in for excel. It's free and easy to work into your application.