Microsoft Office Questions? Ask a IT Expert for Support ASAP
HI, Thanks. File ID above.
I need to calculate commission payable over Threshold (T) on a tiered basis where the first 15k over threshold is paid at 25%, from 15k to 22.5k over threshold at 30% and from 22.5k+ over threshold at 40%.
So, for example,
if someone had a threshold of 28450 and billed 58450 (30k over threshold) they would receive the following commission:
0-15 @25 % = 3750
15-22.5 @30% = 2250
22.5-30 @40% = 3000
TOTAL = 5250
HI the file that downloaded doesn't contain anything other than i uploaded. could you save and resend please?
I see, sorry I obviously wasn't clear:
I need the formula for each tier (cells in column D, E and F) to be calculated at the rate applicable based on the value in Column C.
I need to show the amount paid at each tier, not just the total.
I've uploaded the file with the longhand version of what i'm trying to achieve in the cells. See example 2 on file 482612.
I just downloaded your file and populated column C. The formula is doing something strange. The results should be the same as example 1.
40% column returns incorrect figs when other fields populated. should be calculated on the portion above 22500 over T
have worked it out separately. thanks,
I had to have someone else do this as needed it last night and your answer wasn't consistent with what I had requested.
Thanks for your efforts and I appreciate the speed.