Formula for Tiered Pricing and variable amount of transactions

Hey everyone! I'm new to the forum and looking for help solving the formula for inputing tiered pricing. The pricing is as follows

Transactions per month Monthly Price
Tier One 1-10,000 transactions $1,000
Tier Two 10,001-50,000 transactions $5,000
Tier Three 50,001-150,000 transactions $15,000
Tier Four 150,001-500,000 transactions $30,000
Tier Five 500,001-1,000,000 transactions $60,000

Depending how many transaction per month, there are 5 different tiers each with a unique monthly cost. The other hard part I have yet to figure out how to include is putting in the equation that will help determine how many transactions. As in two different cells, one for users, and the other for the avg. amount of transactions per month, which can be changed accordingly to determine outcome. Say 250 users doing 1 transaction or 5000 users doing 5 transactions.

Thanks so much for anyone that can help me out! Here is a link to a similar forum that didn't quite have the response I needed. http://www.excelforum.com/excel-form...d-pricing.html

Is this something that is of to much difficulty, that would be better served posting in commercial services?

Maybe something like this for the first part

Data Range

	A	B	C	D	E	F	G	H	I
1	Tier	Transactions	Price		Transactions	Price
2	One	1	1000		65000	15000
3	Two	10001	5000		Formula	=VLOOKUP(E2,$B$2:$C$6,2,TRUE)
4	Three	50001	15000
5	Four	150001	30000
6	Five	500001	60000

Really need a better explanation with examples for the remainder of your request. I am not understanding what you want to achieve.

I don't know how to make a table on this forum but the wording would be column A and then Column B would be The month and then the numerical values. So if i had 150 users using my service and they each had 1 transaction that month than the cost would be $1000 because I would still be in the Tier 1 range with only 150 transactions. I want to be able to change the variable amount in the cells, say now theres 2000 users and they each had 20 transactions the next month, which would put me in tier 2 with 40,000 transactions and cost $5000. I'm looking to put in a formula for the "Monthly cost" row where it would generate either the $1000 or $5000 for me. Thank you so much for the help already!

Month 1
Total Users 150

Monthly Cost $1000

Average transactions per user 1

Month 2
Total Users 2000

Monthly Cost $5000

Average transaction per user 20

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Is this what you had intended?

It's still a bit of a guess. If not...

Will you please attach a SMALL sample Excel workbook (10-20 rows of data is usually enough)? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).

1. Make sure that your sample data are truly REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired solution is also shown (mock up the results manually).

3. Make sure that all confidential information is removed first!!

4. Try to avoid using merged cells. They cause lots of problems!

Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

@Dallen
Thanks for letting us know. It will be beneficial for participants in this forum who may have a similar issue to know how you solved this. Please tell us so others searching this site may benefit from your experience and knowledge. Also, please take the time to mark this thread as solved. These are common forum courtesies you will find throughout the web.