Hi, im looking for some help and my work laptop wont let me run XL2BB.
In D8 i am use =IF(AND(C4>10, C8>0), "5", "0")
And need help with the forumula for D10?
I am also looking for an formula which will sum total each of the eligible plan credit .
For example, Total Eligible Credit=(B6*D6)+(B7*D7)+(B8*D8)+(B9*D9)
= 0 + 15 + 50 + 91
= 156
Thanks in advance.
In D8 i am use =IF(AND(C4>10, C8>0), "5", "0")
And need help with the forumula for D10?
I am also looking for an formula which will sum total each of the eligible plan credit .
For example, Total Eligible Credit=(B6*D6)+(B7*D7)+(B8*D8)+(B9*D9)
= 0 + 15 + 50 + 91
= 156
A | B | C | D | E | |
1 | Charge 1 | 3 | |||
2 | Charge 2 | 12 | |||
3 | Total | 13 | |||
4 | |||||
5 | unit | max credit | unit credit | condition/explanation | |
6 | Plan A | 1 | 0 | 0 | no credit available |
7 | Plan B | 3 | 5 | 5 | If B3>=10, a $5 credit per Plan B service |
8 | Plan C | 5 | 10 | 10 | If B3>=10, a $10 credit per Plan C service |
9 | Plan D | 7 | 15 | 13 | If B3>=10, upto a max $15 credit per Plan D service , ie if B3 is 13, then a $13 Credit is available |
10 |
Thanks in advance.