Excel Formulas

[John_Coleman]

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?

[#2]

Hi @John_Coleman 

Assuming the number is placed in C1 then you may use below formula:

=IF(C1*75%<7500,C1*75%,7500)

Thanks

Tauqeer

[#3]

@John_Coleman 

By the way

X = lesser of (7500 or 75% of 12,000)  

is translated to Excel as

= MIN(7500,75%*C1)