TravelBugCopper ContributorSep 17, 2020Excel formula for minimum charge or % of transaction, whichever is higherHi, I need a formula to calculate charges as follows: standard charge is 3% or minimum charge of $10 will apply, whichever is greater.
2 RepliesReplies sorted by NewestJMB17Bronze ContributorSep 17, 2020=Max(0.03*x, 10) where x is the number 3% is applied to.TravelBugCopper Contributor to JMB17Sep 17, 2020Thank you for your prompt assistance.
