Hi,
I am trying to calculate commissions at various levels and am new to IF statements, after trying several times I thought I had it solved, but I just cant get it to work properly.
I just need a fully working example for one and I can do the rest!
Can anyone help?
Spreadsheet is attached.
Basically I just want to get row 39 working properly, so for this instance we only calculate it using Rows 21,22,23.
You take the fee billed (B26) and then for the various tiers you work out how much you earnt.
Fee = $30,000
The 1st tier; $0-$4,000 you get 0% on, so nothing.
The 2nd tier; $4,001 - $12,000, you get 45% on. So $7,999 * 45% = $3,599.55
Then you still left over $30,000 - $12,000 = $18,000 which gets calculated against the highest tier at 50% = $9,000
so total comm's = $9,000 + $3599.55 = $12599.55
but if your fee = 0, then comm's should = 0.
Anyways I have tried heaps of different ways to get it to work, i got the highest tier working, then the second and even the third. but if i just put 0 i was getting a negative returned.
Help please!
Bookmarks