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

%3CLINGO-SUB%20id%3D%22lingo-sub-1678937%22%20slang%3D%22en-US%22%3EExcel%20formula%20for%20minimum%20charge%20or%20%25%20of%20transaction%2C%20whichever%20is%20higher%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1678937%22%20slang%3D%22en-US%22%3EHi%2C%20I%20need%20a%20formula%20to%20calculate%20charges%20as%20follows%3A%20standard%20charge%20is%203%25%20or%20minimum%20charge%20of%20%2410%20will%20apply%2C%20whichever%20is%20greater.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1678937%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1679010%22%20slang%3D%22en-US%22%3ERE%3A%20Excel%20formula%20for%20minimum%20charge%20or%20%25%20of%20transaction%2C%20whichever%20is%20higher%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1679010%22%20slang%3D%22en-US%22%3E%3DMax(0.03*x%2C%2010)%20where%20x%20is%20the%20number%203%25%20is%20applied%20to.%3C%2FLINGO-BODY%3E
New Contributor
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
=Max(0.03*x, 10) where x is the number 3% is applied to.
Thank you for your prompt assistance.