Excel IF function query

[parulmalik]

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>

 

[parulmalik]

Help giving single formula to calculate gross fee , rebate , net

 

[arthurbr]

Is this some kind of homework?

 

[mole999]

have a read over LOOKUP

 

[parulmalik]

yes this is project please help giving excel formula asap