jvandal009
New Member
- Joined
- May 30, 2015
- Messages
- 1
I want to create a formula that gives me a point for anyone I recruit that does a deal. One full point. Then, to anyone they recruit, they get a point for every deal, and I get a half point. So on and so on. So all I have to do is put in how many deals at the end of the year and the point are added based on the levels above someone you are. The person who does the deal doesn't get any points, only their "family" above them.
Example: Adam recruits Bob. Bob recruits Charles. Charles recruits Dan.
Dan closes 1 deal. So Charles gets 1 point. Bob gets 1/2 a point, and Adam gets a 1/3 point.
Charles does 3 deals so Bob gets 3 points, and Adam gets 3- (1/2) points. Or 1.5 points.
Bob does 2 deals, so Adam is the only one who gets 2 points for Bob's deal.
I want it to be able to be very large and be able to have unlimited depth.
Thansk.
Example: Adam recruits Bob. Bob recruits Charles. Charles recruits Dan.
Dan closes 1 deal. So Charles gets 1 point. Bob gets 1/2 a point, and Adam gets a 1/3 point.
Charles does 3 deals so Bob gets 3 points, and Adam gets 3- (1/2) points. Or 1.5 points.
Bob does 2 deals, so Adam is the only one who gets 2 points for Bob's deal.
I want it to be able to be very large and be able to have unlimited depth.
Thansk.
Last edited: