# Tier Pricing help

1. ## Tier Pricing help

Hi all,

Hoping someone can assist with the below, I have tried a couple of ways to do this but can't seem to get the result I am after.

What I am trying to do is count the number of transactions between each band and charge at the rate according to the band.

For example, a customer has total of 250 transactions so 200 @ 0.04, plus 50 @0.02 = \$9 Total due by customer

The bands I am after are the below:

Band Start Band End Fee Per transaction
0 200 0.4
201 300 0.02
301+ 0.01

Thanks for any assistance you can provide in advance...

2. ## Re: Tier Pricing help

Try this...

A2 = number of transactions

=SUMPRODUCT(--(A2>{0;200;300}),(A2-{0;200;300}),{0.04;-0.02;-0.01})

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1