# Excel IF function query

#### parulmalik

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

### Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

#### parulmalik

##### New Member
Help giving single formula to calculate gross fee , rebate , net

#### arthurbr

##### Well-known Member
Is this some kind of homework?