Multi-tiered multiplication

First time poster and somewhat novice user.

I'm running across a project that requires multi-tiered multiplication and wondering if I'm in the right place or way over my head (I believe both to be true).

Here is an example using generic numbers:

The entered value is 300

The first 100 of that value needs to be multiplied by 5 (500)
The next 150 needs to be multiplied by 4 (600)
The next 250 (or last 50 in this case) needs to be multiplied by 3 (150)

1,250 total.


I'm guessing this is so simple I missed it, or way past my abilities. I believe the latter to be true but would love a starting point to start educating myself. In reality, the task would be easy enough for me to do by hand but looking to improve my skills.

Beautiful. I had a feeling I was making it more difficult than it needed to be. My project is a bit more complicated but this is exactly what I needed as a starting point. Thanks so much and have a great day!

In my excitement, I spoke to quickly.

What I was hoping for was a reusable function/formula that allows A1 to be modified/recalculated.

Example:

I plug "125" into A1

The first 100 x5
The remaining 25 x4

I plug "275"

The first 100 x5
The next 150 x4
The remaining 25 x3

So on, so forth.

Thanks again, Fortis. Using your previous logic, I tried plugging it into an IF function and started rolling about 20 minutes ago. Not that I'm taking credit by any means....lol