excelrooki
New Member
- Joined
- Jun 4, 2014
- Messages
- 2
A | B | C | D | E | F | G | |
1 | Balance | Fee ID | Service Fee | Fee ID | From Bal | To Bal | Service Fee |
2 | $112.34 | 1 | 1 | $0 | $499.99 | $10 | |
3 | $112.34 | 2 | 1 | $500 | $1,499.99 | $20 | |
4 | $1234.21 | 1 | 2 | $0 | $499.99 | $5 | |
5 | $342.12 | 2 | 2 | $500 | $1,299.99 | $15 | |
6 | $785.87 | 2 | 2 | $1,300 | $1,499.99 | $25 | |
<tbody>
</tbody>
I need some help calculating the service fee based on the Balance and the Fee ID.
Example:
C2 should have a value of $10 since A2 is $112.34 and Fee Id is 1,
C3 should have a value of $5 since Balance is $112.34 and Fee ID is 2.
C4 should have a value of $20 since A4 is $1234.21 and Fee ID is 1
Thanks,
Jason