计算委员会的条件公式 [英] Conditional Formula for Computing Commissions
问题描述
您好，
我希望这对某人来说很简单。我总是自己弄清楚事情，但我认为看看是否有其他人认为这是非常简单并且知道答案真的很棒。这里是：
我正在制作一份Access报告，详细说明每个月的销售额，然后总计底部的总数（我完成了所有这一部分），并根据总和，使用适当的百分比率来计算佣金。我希望我有意义。
这是基于总销售额的工资率。
0？ 499K = .03％
500k？ 999K = .0325％
1M？ 1.9M = .035％
2M？ 2.9M = .0375％
3M + = .04％
如何编写一个查看总销售额并基于总销售额的查询公式数字是否使用正确的费率来计算佣金？
希望这对某人来说听起来很有趣。可能比山丘老了。
谢谢你，问候，
pollyanna
Hi there,
I hope this is simple for someone. I always figure things out myself, but I thought it would be real nice to see if anyone else out there thought this was super simple and knew the answer. Here goes:
I am working on an Access report that details individual sales by month, then sums the total at the bottom (I have all this part done), and based on the sum, uses the appropriate percentage rate to calculate the commission. I hope I am making sense.
Here is the pay rate based on total sales.
0 ? 499K = .03%
500k ? 999K = .0325%
1M ? 1.9M = .035%
2M ? 2.9M = .0375%
3M+ = .04%
How do I write a query formula that looks at the total sales and based on the total sales number uses the correct rate to calculate the commission?
Hope this sounds fun for someone. Probably old as the hills.
Thank you and regards,
pollyanna
推荐答案
你在我看来有两个选项：
You have two options it seems to me :
- 做一个复杂的IIf（）结构（只有5个级别，它不会那么复杂）。
- 创建一个包含结构的表并链接到该表。
您是否需要有关如何执行此操作的更多详细信息？这只是一次智力锻炼吗？
如果你想要充实这两种想法，请回答你需要的东西。
Do you need more details on how to do this? Is this simply an intellectual exercise?
If you want a fleshing out of either idea please respond with what you need.
像......这样的东西。 >
=格式（IIf（Sum（[SalesField]）< 500000,0.03，IIf（Sum（[SalesField]）> = 500000和Sum（（[SalesField]）< 1000000， 0.0325，IIf（Sum（[SalesField]）> = 1000000和Sum（（[SalesField]）< 2000000,0.035，IIf（Sum（[SalesField]）> = 2000000和Sum（（[SalesField]）< 3000000,0.075，IIf（Sum（[SalesField]）> = 3000000,0.04）））））/ 100，" ## 0.0 ##％"）
Something like ...
=Format(IIf(Sum([SalesField])<500000, 0.03, IIf(Sum([SalesField])>=500000 and Sum(([SalesField])<1000000, 0.0325, IIf(Sum([SalesField])>=1000000 and Sum(([SalesField])<2000000, 0.035, IIf(Sum([SalesField])>=2000000 and Sum(([SalesField])<3000000, 0.075, IIf(Sum([SalesField])>=3000000, 0.04)))))/100, "##0.0## %")
在我看来，你有两个选择：
You have two options it seems to me :
- 做一个复杂的IIf（）结构（只有5个级别） 这很复杂。
- 创建一个包含结构的表并链接到该表。
您是否需要有关如何执行此操作的更多详细信息？这是只是一个智力锻炼？
如果你想要充实的充实想法请回复你需要的东西。
Do you need more details on how to do this? Is this simply an intellectual exercise?
If you want a fleshing out of either idea please respond with what you need.
问候！谢谢。
我倾向于选择复杂的IIf（）结构（只有5个级别，它不会那么复杂）选项。
这是我试着拥有自己的东西，但我不知道如何构建关卡。
一切是一种智力锻炼。 :)这也是我正在制作的销售报告中的一个小路障。
是的，拜托。我想帮忙。
Greetings! Thank you.
I am inclined to pick the "complicated IIf() structure (with only 5 levels it wouldn''t be THAT complicated) option."
This is what I was tryin got do own my own, but I didn''t know how to structure the levels.
Everything is an intellectual exercise. :) It is also a little road block in the sales report I am making.
Yes, please. I would like help.
这篇关于计算委员会的条件公式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
