First time poster. Been using Excel for awhile. I am not a savy user by any means, so this may be an easy question.

Here is what I am needing:

I have three values for for a row:
A minimum value
A maximum value
An known number

What I need is a way to insert a command in a cell that will create a number that doesn't exceed the min/max values in each column, but can be multiplied by the known number.

Example:

A product has a minimum value of '100' and a maximum value of '500' and an known value of '40'.

The function would be able to assign a value in a 4th cell - between 2.5 and 12.5 (it doesn't matter which value it returns, as long as it is correct), as those would be the only correct answers. I am unsure if this requires a macro which tries every number until it is greater than the minimum or what.

I hope I have explained this properly. If you need an Excel spreadsheet with what I need, I can do that (but I don't have it available to produce at this very second).

Thank you so much for your time.