Can you do this with formulas?

[excelos]

Hello,

Is it possible to calculate the min value of an input cell that its value is used to other functions, so that a different cell that contains the output of those functions has a specific value?

Thanks!

 

[RoryA]

It sounds like you need Solver to me.

 

[excelos]

It sounds like you need Solver to me.

I did try, but it said there are circular references.

What is solver?

 

[RoryA]

It's an add-in for solving problems like this. (I would think you'd know that if you tried it already?)

 

[excelos]

It's an add-in for solving problems like this. (I would think you'd know that if you tried it already?)

Thanks, I know learned what Solver is. Unfortunately I need an alternative solution.
Can it be done with functions or macros?
The last resort would be a macro that will fill a specific cell with 0, 1, 2, 3, etc until a target cell becomes 0 (following the functions that determine that cell)
Can you help me please?