excel中的部分
我很难为此项目提出可拖动代码。
任何100或以下都很简单，我只使用= ifs（H6＆lt; e7，h6*f6） 但是我不确定该怎么办。如果我在600处将其编码为（100 *2 + 400 *4 + 100 *6）。
我正在为我应该做的事情画一个空白，任何帮助将不胜感激。
I'm having trouble coming up with a dragable code for this project.
Anything 100 or under is simple, I just used =IFS(H6<E7,H6*F6)
But above 100, I'm not sure what to do. If I hand coded it at 600, it would be (100 *2 + 400 *4 + 100 *6).
I'm drawing a blank on what I should do, any help would be appreciated.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
这里非常有趣的查找问题！我给了一些想法，并提出了应该有帮助的事情。
我水平布置括号，这样：
我在H列中有输入，列i为空白，括号开始于列J。
因此，首先我们查找每个存储桶的单价。很容易，普通的旧Vlookup可以做到。因此，J6有一个：
在此下面，在第14行中，我已经制作了此范围的副本，这次是计算属于每个存储桶下方的单位数量。这个很有趣，可以简化，但这是我在J14中的内容：
然后我在下面制作了另一个副本，以乘以两张桌子，所以我在J22中使用了这一点：
通过完成下面的金额的总和每个支架，我们都会得到我们要寻找的东西：
SO SO，肯定可以清除助手范围，但随后它变成了一个怪物配方，很难调整和/或稍后调试 - 最好的解决方案是这样做还是保持助手范围（也许移动或隐藏）取决于您！
略有编辑，要进行查找工作，您要么需要一个顶部支架，要么将9999999的上限作为“ 1000+”支架的上限。
Very interesting lookup problem here! I've given it a few thoughts and came up with something that should help.
I've laid out the brackets horizontally, like this:
I have the inputs in column H, column I is left blank, and the brackets begin in column J.
So first we lookup the unit price per bucket. Easy enough, a plain old VLOOKUP will do. So J6 has this:
Underneath this, in row 14, I've made a copy of this range, this time to calculate the number of units that belong under each bucket. This one was fun to come up with and could probably be simplified, but here's what I have in J14:
Then I made another copy underneath to just multiply the two tables, so I have this in J22:
By making the sum of the amounts under each bracket, we get what we're looking for:
So, with a little bit of clean-up the helper ranges can certainly be removed, but then it becomes a monster formula that's pretty hard to tweak and/or debug later - whether the best solution is to do that or keep the helper ranges (and move or hide them, perhaps), is up to you!
Slight little edit, for the lookups to work you either need one more top bracket, or to have something like 9999999 as the upper bound for the "1000+" bracket.