youssieboud
New Member
- Joined
- May 22, 2021
- Messages
- 1
- Office Version
- 2019
- Platform
- Windows
Hello everyone,
I'm trying to use the solver in Excel multiple times (in a loop), but I can't figure out how to do it.
I want the F19 cell as changing value and I want to set N15 to 0.10. First, I want to do this for a volume of 100 m3 (N3=100). Using the solver for this procedure works excellent. But now, I want to use the solver for increasing values of the volume, from V=100 up until V=12.000 for example, while using loops. And I also want to capture those iterated values for each step.
Can someone help me out?
I'm trying to use the solver in Excel multiple times (in a loop), but I can't figure out how to do it.
I want the F19 cell as changing value and I want to set N15 to 0.10. First, I want to do this for a volume of 100 m3 (N3=100). Using the solver for this procedure works excellent. But now, I want to use the solver for increasing values of the volume, from V=100 up until V=12.000 for example, while using loops. And I also want to capture those iterated values for each step.
Can someone help me out?