Math within a formula.

[Oteshatori]

Let's say in B12 I have a number between 1 and 4+.
Now, let's say in cell B16 I want something like: if B12 = 1 then $0, if B12 = 2 then 2*$10, if B12 = 3 then 3*$15, if B12 = 4 then 4*$20, if B12 = greater than 4 then that number *$20.

My head hurts now, but that's the idea. Any thoughts on making such a whacky thing happen?

 

[Fluff]

you're right I'm on Excel 2016 now.

In that case, I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)