Hi all excel gurus,
Trying to work out tiered bonus for my project. I have two scenarios with different criteria to calculate bonuses. Could you please assist based on attached?
Thank you.
S
Hi all excel gurus,
Trying to work out tiered bonus for my project. I have two scenarios with different criteria to calculate bonuses. Could you please assist based on attached?
Thank you.
S
In F4 try
=SUMPRODUCT(--(F3>{0,58000000,63000000,68000000}),--(F3-{0,58000000,63000000,68000000}),{0,0.025,-0.0025,-0.0025})
in F21 try
=SUMPRODUCT(--(F20>{0,69000000,74000000}),--(F20-{0,69000000,74000000}),{0.025,-0.005,-0.005})
Last edited by 63falcondude; 06-14-2017 at 09:10 PM.
Thank you.
Just trying to follow the formula, is there a way i can link the hard coded $ in the formula to the cells that they relate to (i tried linking but to to luck). Also, dont seem to follow the rates you've used.
S
That complicates the formula quite a bit but here it is. I changed the tables to work with the formula.
The rates that you are referring to are the difference of the rates. See attachment for clarification.
Source: https://www.mrexcel.com/forum/excel-...cing-grid.html
Thanks for the rep!
If that solved your question, please mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks