Try something like this:

=MIN(B10*20%,2700)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Mary A Perez" wrote:

I need to take the $ amount in b10 & mulitply it my 20% but tell the formula
that if the result is $2,700 just put $2,700 in the answer.
Can someone write this out for me?
Thank you