Atholl
Active Member
- Joined
- May 19, 2002
- Messages
- 434
Hi folks,
I've a worksheet where I want to alter a variable, which will subsequently alter a value which I want to get as close numerically to another value. The value of the variable which satisfies this is of interest to me (I hope I've explained that clearly!). I know the solver will do this, but is there a way to do this using circular references or something? The Excel help wasn't much help to me in this case!
Thanks,
Atholl
I've a worksheet where I want to alter a variable, which will subsequently alter a value which I want to get as close numerically to another value. The value of the variable which satisfies this is of interest to me (I hope I've explained that clearly!). I know the solver will do this, but is there a way to do this using circular references or something? The Excel help wasn't much help to me in this case!
Thanks,
Atholl