Excel IF function query

parulmalik

New Member
Gross Fee$ % Rebate
To250000%
25001$5000010%
50001$10000015%
100001$20000020%
200001$50000025%
500001$1000000030%

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

Some videos you may like

This Week's Hot Topics

Top