ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Ranges and Number Combinations (https://www.excelbanter.com/excel-programming/411249-ranges-number-combinations.html)

KRVMO

Ranges and Number Combinations
 
I have three parameters that are given to me in ranges, so I have A is 20 to
30, B is 95 to 125, and C is 5 to 10. I want to go through the ranges in
increments of 5 for A and B, and in increments of 1 for C. So I would be
able to put in different max and mins and it would still calculate from 40 to
50 in increments of 5 for A if I changed it. I then have an equation I need
to put A, B, and C into and I need to find the answer for all the possible
combinations of all the increments of A, B, and C. I then need to find which
of those solution is between a range given for a fourth value D, and then
have the program give me the values of A, B, and C that gave the solution
that was in the range set by D. I know this is confusing but any help would
be greatly appreciated.


All times are GMT +1. The time now is 02:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com