parulmalik
New Member
- Joined
- Nov 6, 2016
- Messages
- 3
Gross Fee | $ | % Rebate | |
To | 25000 | 0% | |
25001 | $ | 50000 | 10% |
50001 | $ | 100000 | 15% |
100001 | $ | 200000 | 20% |
200001 | $ | 500000 | 25% |
500001 | $ | 10000000 | 30% |
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
Test 1: Create a spreadsheet to make this calculator work where the Gross Fee is the only input to calculate the Rebate and Net. Model needs to work for any Gross Fee input value. | ||||||||||||||||||
Test 2: Instead of using the visuals above, create a single formula field to calculate the Rebate and one to calculate the Net but referencing only the Gross Fee. Single formula means Rebate = Gross Fees – [THE FORMULA] and Net = Gross Fees – [THE FORMULA]. | ||||||||||||||||||
Test 3: Using Test 1 and 2, calculate Rebate and Net from the Gross Fee of 9,542,332.56. | ||||||||||||||||||
Help: Model needs to work for any value. Single formula means Rebate = Gross Fees – [THE FORMULA] and Net = Gross Fees – [THE FORMULA]. | ||||||||||||||||||
<colgroup><col span="19"></colgroup><tbody>
</tbody>