Need formula to calculate total of different rates depending on count

Not sure if my title is accurate of my problem; I struggled to find the right description.

I need a formula to be able to calculate a total of different rates depending on the item total. By this I mean:

For one item, I charge $75.
For multiple items, I charge $75 for the first and $25 for each additional.

One item would total $75, 3 items would total $125, 5 items would total $175 and so on.

Does anyone have any suggestions of how I can calculate this with an excel formula? I am using Excel 2010.

Let me know if you need any additional information.

Thanks for your help.

Laura

Suppose you have the number sold in F2. Then you could use this formula:

=IF(F2="","",75 + (F2-1)*25)

and then copy it down if required.

Hope this helps.

Pete

Perfect! Thank you very much!

You're welcome, Laura.

Please mark the thread as Solved if you consider it to be so (click on Thread Tools above your first post).

Also, you can pass on thanks more directly to a contributor by clicking on the "star" icon in the bottom left corner of any post you have found to be helpful.

Pete

Thanks for the forum etiquette tips, Paul! I actually have a follow up question now though.

Your formula works great if there is a value in F2; however, if I leave F2 blank, my calucation shows $50. I tried studying your formula to see if I could figure it out, but haven't had any such luck yet. Any ideas?

Thanks!

I don't know who Paul is, but the only way you can get $50 is if you have -2 in F2. If you leave F2 blank then you should get a blank result. Post the formula that you are using.

Pete

D'oh! Sorry, Pete!

I will give more detail about my issue (and for your reference, I am selling images.)

B27 (number of files types)
C27 (number of views per file type)
D27 (total number of images purchased) FORMULA: =SUM(B27*C27)
E27 (total cost of images purchased) FORMULA: =IF(D27="","",75 + (D27-1)*25)

Thanks for your help!

Laura

Actually, I think I've got it figured out:

=IF(D27=0,"",75 + (D27-1)*25)

Thanks again for your help!

Laura