![多个 IF 条件,结果是多个计算之一 - Excel](https://linux22.com/image/1353139/%E5%A4%9A%E4%B8%AA%20IF%20%E6%9D%A1%E4%BB%B6%EF%BC%8C%E7%BB%93%E6%9E%9C%E6%98%AF%E5%A4%9A%E4%B8%AA%E8%AE%A1%E7%AE%97%E4%B9%8B%E4%B8%80%20-%20Excel.png)
我需要根据数字在特定范围内的位置应用不同的倍数。例如:
IF >1000000 is the base, THEN base minus 1000000, multiplied by .015+25000
IF >150000<1000000 is the base, THEN base multiplied by .025
IF <150000 is the base, THEN base multiplied by .030
这就是我想出的(b5=base):
=IF(b5>1000000),(B5-1000000)*0.015+250000,IF(B5>150000<1000000),B5*0.025,IF(B5<150000),B5*0.03
我错过了什么?mb
答案1
你可以用这个公式来实现:
=IF(B5>1000000,(B5-1000000)*0.015+25000,
IF(B5>150000,B5*0.025,
B5*0.03))
请注意,您的问题不一致 - 您可能需要替换+25000
为*25000
!