如何找到2个条件的2个数字之间的百分比？
我很难找到百分比的公式 我必须计算员工奖金 例如，在2022年4月8日，我们有90.13％的标准，在04/04/2022上是108.54％ 其中90％等于奖金的3.75％，最多120％等于奖金的15％以下，低于工作规范的90％，员工将无法获得奖金，
我需要找到一个公式，该公式将如何计算如何计算much the employee's bonus will be
https://docs.google.com/电子表格/D/1XTF9ZUECAHZTNB6DNKQAKMO7E1QTMV6QBNHSQ0WWPI0/EDIT＃GID = 51882774
89.99％= 0％
90％= 3.75％90.13％= 3.75％
90.13％= ????
108.54％= ???
120％= 15％
130％= 15％
140％= 15％
150％= 15％
任何人可以帮助我吗？
I'm having trouble finding the formula for percentages
I have to calculate the employee bonus
e.g. on April 8, 2022, we have 90.13% of the standard developed, the same on 04/04/2022 is 108.54%
where 90% is equal to 3.75% of the bonus and a maximum of 120% is equal to 15% of the bonus below 90% of the worked norm, the employee will not receive a bonus
I need to find a formula that will calculate how much the employee's bonus will be
89.99% = 0%
90% = 3.75%
90.13% = ???
108.54% = ???
120% = 15%
130% = 15%
140% = 15%
150% = 15%
Anyone can help me with this ??
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
由于某种原因，我的浏览器不会查看图像，因此在此答案中，我假设“已开发的标准百分比”是A列，请将单元引用更改为西装。
在单元格（或不同的列）中，输入公式；
My browser won't view the image for some reason, so in this answer I'm assuming that the 'Percentage of standard developed' is column A, please change cell references to suit.
in Cell B2 (or a different column) enter the formula;
这是一个动态公式，用于覆盖您指定的范围。它将帮助您了解如何提出数字。鉴于有条件的格式，我认为您已经知道何时不应用它。
基本上，您从下限开始以达到百分比
3,75然后，您计算出从90的步骤数量，并将步骤数乘以步长范围（120-90）到百分比范围（15-3,75）的比率。
Here is a dynamic formula for covering the range you specified. It will help you understand how to come up with the numbers. Given the conditional formatting, I think you already know when not to apply it.
Basically you start with the lower bound for the percentage
3,75 then you calculate how many steps you took from 90 and multiply the number of steps by the ratio of step range (120 - 90) to the percentage range (15 - 3,75).