calculate the commission for each client automaticaly

This is quite simple in excel.. however you mentioned that commission will be certain percentage of premium.. is this fixed...

if not can you provide what percentage of premium will be the commission...

probably 2 or 3 examples with sample data and calculation will be helpful

Basically i want to know the condition which determine the commission..
eg. if the company is xyz and policy type is one then percentage of premium will be 15%.
otherwise if company type is abc and the policy type is tow then percentage of premium will be 20%..
A detailed table of this condition is need to write the query

thanks for your reply

commission is a set percentage for a given company and given policy type, for example Travelers auto policy pays 15% of the premium and 12% on the home, Safeco Home pays 10% and auto 20%.

I would like the program to recognize the name of company and type of policy and apply the appropriate commission percentage.

I attached the new file with an example in there.

Hi,

For this you need to create a table which containe the company name , policy type and percentage...
Eg... See Column K , L , and M.

Then you need to you the formula which I have typed in Column I.

={SUM(($K$4:$K$7=D4)*($L$4:$L$7=E4)*$M$4:$M$7)*G4}

Dont type the Curly braces in the forumla "{}".
Do not press Enter Key.
After the formula is typed press Ctrl + shift + enter.