Hi,
I'm pretty new to Excel and I'm trying to do something where excel solves an equation for me and solves it again whenever I add new data in a table I made. Basically I need Excel to solve an equation to equal a specified cell, however the Solver under "Data" doesn't let me add the value of a specific cell in the Value Of:, only specific numerical values. I tried instead using the SolverOk function after some googling, but now I get a #VALUE!. This is my attempt:
Is this because I'm trying to do it directly in a cell instead of in VBA?Please Login or Register to view this content.
Thanks in advance.
Bookmarks