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

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

parulmalik

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

arthurbr

Well-known Member
Is this some kind of homework?

mole999

Moderator
have a read over LOOKUP

parulmalik

New Member
yes this is project please help giving excel formula asap

Threads
1,095,708
Messages
5,446,047
Members
405,378
Latest member
pvergili