电子表格/VBA 计算多层次营销收入
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/22680379/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
spreadsheet/VBA to calculate multi-level marketing income
提问by M. H
I am trying to help a friend who wants to set uo a MLM organisation. He needs to calculate income for everyone he will enroll.
我想帮助一个想要建立一个传销组织的朋友。他需要计算他将招收的每个人的收入。
The issue is that a top-level employee gets his own commission PLUS a percentage of everyone's commission he has enrolled...
问题是顶级员工获得自己的佣金加上他注册的每个人的佣金的百分比......
[Do] ...these guys in turn get their own commission PLUS also a percentage of everyone's commission that they have enrolled, and this additional commission also has an upstream effect on the top level guy's percentage (this goes all the way down the line)... [Loop]
[做] ...这些人依次获得他们自己的佣金加上他们注册的每个人的佣金的百分比，这个额外的佣金也对顶级人的百分比有上游影响（这一路下降）... [环形]
potentially, this goes on ad-infinitum. So I can't calculate the upstream commission until I have calculated the commission right down to the bottom, but there may be hundreds of levels.
潜在地，这会无限期地进行。所以我不能计算上游佣金，直到我把佣金计算到底部，但可能有数百个级别。
In the data I'm looking at, I know everybody's sales and I know the ID no. of the person who has enrolled them, I don't necessarily know how far down a chain they are.
在我查看的数据中，我知道每个人的销售额，我知道 ID 号。在注册他们的人中，我不一定知道他们在链条上有多远。
How can I model this for him? I can't get my head round it.
我怎样才能为他建模？我无法理解它。
Has anyone else ever had to work this out? Am I missing something obvious?
有没有其他人不得不解决这个问题？我错过了一些明显的东西吗？
Thanks
谢谢
回答by user4436220
You have typo error in following formula:
您在以下公式中有错字错误：
=SUMIFS([Upstream commision - outgoing],[Parent ID],[ID])
shoud read
应该读
=SUMIFS([Upstream commission outgoing],[Parent ID],[ID])
