Hi

I want to build a pricing model for a web application. I need a formula for cell that will calculate the cost of the product given a variable. The price of the product is dependent on the number of people that sign up for it - this is the variable. The price per person diminishes as the number of people rises.

Example Pricing Structure:

0-50 People - $50 per person
51 - 100 People - $40 per person
101 - 150 People - $30 per person
151 - 200 People - $20 per person
201 - 250 People - $10 per person
251 - 300 People - $5 per person
301+ People - $2.5 per person

So, if 152 people sign up, the client will be charged (50*50) + (50*40) + (50*30) + (2*20) or $6040.

Other Example Outcomes:

50 People = $2,500
75 People = $3,500
125 People = $5,250
200 People = $7,000

My goal is to create a pricing sheet in xls that will produce a price given the variable - a number of people that will be in the application.

Many thanks in advance and apologies if this is answered elsewhere.

A