Cost price based on different markup rates vs price

Hi

Hopefully someone can help (read shameless request for some formula help!) , I have searched the forum and can't quite find the help I need, Maybe its just a case of cannot see the wood for the trees etc.

In a nutshell this is the situation. I have been asked at very short notice to create a Excel that will take a numerical value in Cell A6 and then based on that amount apply a multiplier and show the result in cell E6. So if the value in A6 is less than 9.99 the result will be multiplied by 50% so I get that E6=A6x1.5 however the multiplier changes based on the value in A6 and this is the bit I am struggling with. The values are below:

1-9.99 = 1.5 (50%)
10-49.99 = 1.33 (33%)
50 - 249.99 = 1.2 (20%)
250 - 1000.99 = 1.15 (15%)
>1001 = 1.10 (10%)

Hope that makes sense, Anyone who can help will receive my eternal gratitude

Thanks

either

E6: =A6*LOOKUP(A6,{0,10,50,250,1001},{1.5,1.33,1.2,1.15,1.1})
or
E6: =SUMPRODUCT((A6>{0,10,50,250,1001})+0,A6-{0,10,50,250,1001},{1.5,-.17,-.13,-.05,-.05})

depending on your exact requirement.

with a value of 15 in A6 the first would return 19.95 (15 * 133%), whereas the second would return 21.65 as it applies a tiering (marginal calc) to the value i.e. 10 * 150% + 5 * 133%

That is excellent, Really appreciate the help!