Nov 16 2019 10:51 AM
I want to create a macro that calculates a product that is the lesser of a specific number or 75% of another number - ex, X = lesser of (7500 or 75% of 12,000)
The numbers would tie to a cell
What is the formula?
Nov 16 2019 11:10 AM
Assuming the number is placed in C1 then you may use below formula:
=IF(C1*75%<7500,C1*75%,7500)
Thanks
Tauqeer
Nov 16 2019 11:48 AM
By the way
X = lesser of (7500 or 75% of 12,000)
is translated to Excel as
= MIN(7500,75%*C1)