A could be less than or more than 10% but the result can never be more than
5% of B. I don't know the formula to limit the result to 5%.

"David Biddulph" wrote:

Whatever value you have for A1 will be used in the formula.
--
David Biddulph

"Donna" wrote in message
...
Thanks, David. What if A is variable?

"David Biddulph" wrote:

=MIN(A1*B1,B1*.05) or
=B1*MIN(A1,0.05)
--
David Biddulph

Donna wrote:
A B
10.000 1,262.61
What is the formula for saying A * B but not greater than B * .05