calculating a certain cell to add at different prices

M

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?
 
P

Paul

Melissa said:
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?
Click to expand...

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