CuriousForge
New Member
- Joined
- Aug 20, 2018
- Messages
- 24
Hello good people of Mr Excel.
Need an alternative to the Goal Seek function in whatever form possible (VBA, a formula - anything that works automatically).
Problem: I need to limit the value of column D to max 15% in each line (can be less, but not more).
This should be achieved by changing the values of column B manually with a max threshold of 60% (i.e can be less but not more).
Formulas Used:
Column A - plain text
Column B - plain text
Column C- =A2*B2
Column D - IFERROR(C2/$C$6,0)
The challenge faced is as soon as one value is changed in e.g B2 (60% or less) to meet the limit of D2 (15% or less), the other lines in D3,4,5 jumps to exceed the limit of 15% resulting in an eternal chase to meet the constraints across all lines.
Unfortunately the Solver function has also not helped.
Expected result:
Column D can be less than 15% , but not more.
Column B can be less than 60%, but not more.
Need an alternative to the Goal Seek function in whatever form possible (VBA, a formula - anything that works automatically).
Problem: I need to limit the value of column D to max 15% in each line (can be less, but not more).
This should be achieved by changing the values of column B manually with a max threshold of 60% (i.e can be less but not more).
Formulas Used:
Column A - plain text
Column B - plain text
Column C- =A2*B2
Column D - IFERROR(C2/$C$6,0)
The challenge faced is as soon as one value is changed in e.g B2 (60% or less) to meet the limit of D2 (15% or less), the other lines in D3,4,5 jumps to exceed the limit of 15% resulting in an eternal chase to meet the constraints across all lines.
Unfortunately the Solver function has also not helped.
Expected result:
Column D can be less than 15% , but not more.
Column B can be less than 60%, but not more.
