teehee... try to imagine how happy I am right now.

I just solved a very difficult problem for Part 2 of my commmission-calculation worksheet.

Formulas formulas formulas...

Sometimes things when they come to you, you might think they're very simple works. Yet when you really put your hands together to construct the whole thing, it's not as easy as it seems. Concepts can be very straightforward but the process of building the model to produce a proper calculation mechanism aint simple at all !


Here goes:

How do you actually calculate percentage commissions for insurance agents of 4 different levels when they get promoted to another level? This comes together with compensation %.

There. I spent a day to figure out this model. Lots of logical functions to construct. Not easy, people.

Boss, please appreciate :)