emmalouiseee
New Member
- Joined
- Dec 17, 2018
- Messages
- 2
Hey!
I am having a hard time getting a formula in 1 cell that will do what I need. Maybe it's really easy and I am just having a moment or maybe it's just not possible.
Scenario:
Target between 0-10000 needs to be multiplied by 0.85 THEN anything after this point needs to be multiplied by 0.30
I understand this may not be possible in 1 cell so I have tried splitting it into two but then I am getting another issue where if the value is 15000 I need the first equation to give me 0-10000 at 0.85 and then the second cell to give me 10001-15000 at 0.30 but I tried an IF statement with no luck.
<tbody>
</tbody>
<tbody>
</tbody>
Thanks in advance!
I am having a hard time getting a formula in 1 cell that will do what I need. Maybe it's really easy and I am just having a moment or maybe it's just not possible.
Scenario:
Target between 0-10000 needs to be multiplied by 0.85 THEN anything after this point needs to be multiplied by 0.30
I understand this may not be possible in 1 cell so I have tried splitting it into two but then I am getting another issue where if the value is 15000 I need the first equation to give me 0-10000 at 0.85 and then the second cell to give me 10001-15000 at 0.30 but I tried an IF statement with no luck.
Option One | |||
$ Target | Comm | ||
15000 | 4499.7 | <<<< | 1 Formula to figure out Comms |
<tbody>
</tbody>
Option Two | ||||
$ Target | 0-10000 | 10001+ | ||
8000 | 6800 | 0 | ||
15000 | 3000 | 1499.7 | <<<< | Split into two formulas |
<tbody>
</tbody>
Thanks in advance!