Excel formula for finding a Minimum input based on two variables

I have looked for a solution to this at no avail. I have two variables that create number D31(15)*F18(94.98)=1424.7 Based on this answer I have two whole numbers multiples I can round this an...

Multiples Rounding Example.xlsx10 KB

Formulas & Functions

Need Help

SergeiBaklan
Sep 11, 2017
Hi Kent,

You may try Solver add-in
https://support.office.com/en-us/article/Load-the-Solver-Add-in-612926fc-d53b-46b4-872c-e24772f078ca
https://support.office.com/en-us/article/Define-and-solve-a-problem-by-using-Solver-9ed03c9f-7caf-4d99-bb6d-078f96d1652c

In your case it returns:

Multiples Rounding Example+1.xlsx11 KB

SergeiBaklan

Diamond Contributor

Sep 11, 2017

Hi Kent,

You may try Solver add-in

https://support.office.com/en-us/article/Load-the-Solver-Add-in-612926fc-d53b-46b4-872c-e24772f078ca

https://support.office.com/en-us/article/Define-and-solve-a-problem-by-using-Solver-9ed03c9f-7caf-4d99-bb6d-078f96d1652c

In your case it returns:

Multiples Rounding Example+1.xlsx11 KB

Kent O'Donohue

Copper Contributor

Sep 12, 2017

I was trying to do it in formula form as the users of this equation are not excel savy so I was trying to make it user friendly. However, considering the complexity of what I am trying to do my guess is using solver may be the only option.

Thanks for the help!

Forum Discussion

Excel formula for finding a Minimum input based on two variables

Resources