Need help with formula for tiered pricing
Hello, I'm trying to build a formula that will calculate the appropriate pricing based on a tier. So for example, I have the following tiered matrix: <=250,000 transactions * $0.05 <=500,...
Forum Discussion
Try this
Min([250000, ) * 0.05 // 5 cents times the smaller of 250000 and the # of Transactions.
+
Max(500000, Max(0,-250000))* 0.03 // the inner max keeps the result above zero, the first max limits to 500000
+
Max(0, -500000) * 0.01 // the max keeps the result above zero
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Min([250000, ) * 0.05 // 5 cents times the smaller of 250000 and the # of Transactions.
+
Max(500000, Max(0,-250000))* 0.03 // the inner max keeps the result above zero, the first max limits to 500000
+
Max(0, -500000) * 0.01 // the max keeps the result above zero
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Thanks. I'll give that a try!
------------------------------
ChristinePratts
------------------------------
------------------------------
ChristinePratts
------------------------------
