Excel IF function query

parulmalik

New Member
Joined
Nov 6, 2016
Messages
3
Gross Fee$ % Rebate
To250000%
25001$5000010%
50001$10000015%
100001$20000020%
200001$50000025%
500001$1000000030%

<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>
 

Some videos you may like

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.

mole999

Moderator
Joined
Oct 23, 2004
Messages
10,294
Office Version
2019, 2016, 2013
Platform
Windows
have a read over LOOKUP
 

Watch MrExcel Video

Forum statistics

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

This Week's Hot Topics

Top