if functions to add and subtract values in 2 or more different cells

[Mengo85]

Hello guys,

attached is an excel spread sheet which involves 2 brokers, their assets and client count per year. Also displayed is the asset and client growth per year.

What I am trying to do is the following:

Once broker 2 reaches 130 clients he/she gives away 5 clients (client give away) and the average asset per client to broker number 1. Broker number 1 then receives the new clients with their assests next year. Also Broker number 2 then loses the 5 clients with their assests.

I tried to use the if function but somehow it does not quiet work. I think I have to interate.

Maybe it is easier than I think it is but I cant find a proper solution.

Thank you in advance for your help.

Cheers

Mengo85