calculating a certain cell to add at different prices

[Melissa]

I need to write a formula that sees a number in a certain
cell and then calculates the total based on the number.
For instance, the total number is 350 and I want a
formula that calculates the first 250 at $2.95 each and
the next 100 at $2.75 each. Is that possible?

 

[Paul]

I need to write a formula that sees a number in a certain
cell and then calculates the total based on the number.
For instance, the total number is 350 and I want a
formula that calculates the first 250 at $2.95 each and
the next 100 at $2.75 each. Is that possible?

There are many ways of doing this. One way, for the number in A1:
=(A1*2.95)-(A1>250)*(A1-250)*0.2

 

[Ron de Bruin]

See this example Melissa on Chip Pearson his site
http://www.cpearson.com/excel/pricing.htm