'How to change count after certain value
I'm trying to write a code in Excel that basically counts multiplies valueA by 5 when ValueA<=15. Once valueA surpasses 15 (therefore ValueA>15), it will the multiply ValueA by 9 for the remaining amount value. For example, if ValueA=20, 1-15 will be multiplied by 5, and the 16-20 will be multiplied by 9, to give the total amount.
Can anybody else out with this?
So far, I have:
=IF(AND(A2="LR",B2<=15),B2*5, IF(AND(A2="LR",B2>16....
not sure how to finish off!
Solution 1:[1]
=IF(AND(A2="LR",B2<=15),B2*5, IF(AND(A2="LR",B2>15),B2*9-75, ... Whatever value you want if A2 doesn't equal LR))
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | mugron |