#### 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>