Return possible permutations

[Corne Rademan]

Good day

I need help to complete a gear ratio project.

I have a table with all relevant gear values. For example, it could be values between 25 and 150 etc

I would need excel to test all the values in the table and return the different permutations that meets my standard according to the following formula:

eg (A/B) x (C/D) = 0.314 (the answer is given but needs to include all permutations between 0.3141 and 0.3149)

I have tried to explain the best I can, but I will gladly give more info.

Thank you
Corne

[JohnTopley]

Answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.