excel 连续if公式，意思大概是如果A1>4740并且<=5020，然后计算出结果。

发布网友发布时间：2022-06-02 11:00

共3个回答

热心网友时间：2023-10-16 14:21

公式修改为：
=IF(AND(A1>4740,A1<=5020),(A1-4740)*(1-0.007725)+4740,IF(AND(A1>5020,A1<=5030),(A1-5020)*(1-0.025613)+5017.837,IF(AND(A1>5030,A1<=5123.272),(A1-5030)*(1-0.007725)+5027.636,"")))

或
=IF(OR(A1<=4740,A1>5123.272),"",IF(A1>5030,(A1-5030)*(1-0.007725)+5027.636,IF(A1>5020,(A1-5020)*(1-0.025613)+5017.837,(A1-4740)*(1-0.007725)+4740)))

热心网友时间：2023-10-16 14:21

IF(AND(A1>4740,A1<=5020),(A1-4740)-(A1-4740)*0.007725+4740,IF(AND(A1>5020,A1<=5030),(A1-5020)-(A1-5020)*0.025613+5017.837,IF(AND(A1>5030,A1<=5123.272),(A1-5030)-(A1-5030)*0.007725+5027.636,)))

热心网友时间：2023-10-16 14:22

=IF(AND(A1>4740,A1<=5020),A1-4740-(A1-4740)*0.007725+4740,IF(AND(A1>5020,A1<=5030),A1-5020-(A1-5020)*0.025613+5017.837,IF(AND(A1>5030,A1<=5123.272),A1-5030-(A1-5030)*0.007725+5027.636,)))

excel 连续if公式，意思大概是如果A1&gt;4740并且&lt;=5020，然后计算出结果。

excel 连续if公式，意思大概是如果A1>4740并且<=5020，然后计算出结果。