Forum Discussion
Writing an equation that reduces an argument by "1" until an acceptable value is returned
I’m taking two numbers and multiplying them to compare the product to another set value to determine if the product is less than the value. If the product is greater than the set value, I want to red...
Should all numbers be positive whole numbers? If so:
Let's say one of the factors is in A1 and the other in B1.
The max value for their product is in C1.
The following formula will return an alternative value for B1, if necessary:
=IF(A1*B1>C1, QUOTIENT(C1, A1), B1)
Enter this formula in - for example - D1.