New Contributor

# Excel formula for minimum charge or % of transaction, whichever is higher

Hi, I need a formula to calculate charges as follows: standard charge is 3% or minimum charge of \$10 will apply, whichever is greater.
2 Replies

# RE: Excel formula for minimum charge or % of transaction, whichever is higher

=Max(0.03*x, 10) where x is the number 3% is applied to.

# RE: Excel formula for minimum charge or % of transaction, whichever is higher

Thank you for your prompt assistance.