Forum Discussion

scubastu01's avatar
scubastu01
Copper Contributor
Jan 05, 2023

Formula to adjust cell value until another cell equals 0

I have a budget spreadsheet that has a lot of math based on multiplying or dividing by percentages.  I need a formula that will generate a value up or down until another cell is equal to 0.     For...
excel
Formulas and Functions
Patrick2788's avatar
Patrick2788
Silver Contributor
Jan 05, 2023

scubastu01 

I believe you could do this with Solver.  Set it like this and then click Solve.

 

 

scubastu01's avatar
scubastu01
Copper Contributor
Jan 05, 2023

Ah... "Goal Seek" did the trick.

 

Thanks Patrick... that got me where I need to go. 

Resources