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,000 transactions * $0.03

<=1,000,000 transactions * $0.01

So I created the following:

If(

[Transactions]<=250000,[Transactions]*0.05,

[Transactions]>250000 and [Transactions]<=500000, [Transactions]*0.03,

[Transactions]>1000000, [Transactions]*0.01)

I feel like this is wrong. Like if the # of transactions is greater than 250000, then it's going to price all the transactions at the 250000 rate, as opposed to just the transactions over the tier limit... How can I fix that?

Thanks!

------------------------------

Christine

------------------------------