Dear hive mind,

I am not very good at Excel and my big mouth gets me in trouble sometimes. I told my boss at a new job that I was pretty sure I know how to do this...I don't. Please help!

I would like to enter a quantity in a cell and have multiple prices charged depending on that quantity.

I would like the first item charged at $10.95
Second, $9.45
Third, $8.45
Fourth and above, $7.50 each.

For example, if I enter 15 in the "quantity" cell then the formula would produce the value of $118.85 (1 item at 10.95, 1 item at 9.45, 1 item at 8.45, and the remaining 12 items at 7.50 each.)

This is probably pretty easy for someone out there.

Thanks for your help.

Frank