# 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

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

#### parulmalik

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

#### arthurbr

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

1,106,263
Messages
5,510,179
Members
408,779
Latest member
Lermiapolar

### This Week's Hot Topics

• Turn fraction around
Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
• TIme Clock record reformatting to ???
Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
• TextBox Match
hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
• Using Large function based on Multiple Criteria
Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
• Can you check my code please
Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
• Combining 2 pivot tables into 1 chart
Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...