Hi,
Don is suggesting that you take a completely different approach to the problem, therefore using a completely different way to get the result. The beginning is in the understanding of the task.
You say, if the order is for 5 pcs or less the cost will be $2 etc. From this starting point your concatenated IF functions follow naturally, much like working out 5 * 4 as 4+4+4+4+4.
The alternative is to ask, what will be the cost if the order is for x pcs? from this question the logical demand is for a table, in fact, the very table you have posted. Look for the biggest number in the first column that is smaller or equal to your x and move your finger to the adjacent column to get the answer.
Instead of 7 or more operations you have only two. And if you ever need to adjust your cost you do so by modifying the table, not the formulas that read it.
Don has suggested VLOOKUP. There are other ways, too, and some of them work with any Excel still alive. For you, the shortest way to at least one solution is to post a worksheet that has your table somewhere, a couple of cells where x has been entered somewhere else, and a series of cells where you want a formula that produces the result you describe in your post.
Have a great day!
Have a great day!
Sisyphus
I do this for "honour and country" - much less of the latter, actually.
If I helped you, award points, plenty of them.
If I bored you, deduct points for being too long-winded. (I know, :lol)