 Thanks:  0 Likes:  0

# Thread: Excel IF function query

1. ## Excel IF function query

 Gross Fee \$ % Rebate To 25000 0% 25001 \$ 50000 10% 50001 \$ 100000 15% 100001 \$ 200000 20% 200001 \$ 500000 25% 500001 \$ 10000000 30%

 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].  Reply With Quote

2. ## Re: Excel IF function query

Help giving single formula to calculate gross fee , rebate , net  Reply With Quote

3. ## Re: Excel IF function query

Is this some kind of homework?  Reply With Quote

4. ## Re: Excel IF function query

have a read over LOOKUP  Reply With Quote

5. ## Re: Excel IF function query

yes this is project please help giving excel formula asap  Reply With Quote

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•