=IF(H29<=0.1,0,IF(AND(H29>0.1,H29<=0.2),100,IF(AND(H29>0.2,H29<=0.3),300,IF(AND(H29>0.3),500,IF(H29> 10

=IF(H29<=0.1,0,IF(AND(H29>0.1,H29<=0.2),100,IF(AND(H29>0.2,H29<=0.3),300,IF(AND(H29>0... =IF(H29<=0.1,0,IF(AND(H29>0.1,H29<=0.2),100,IF(AND(H29>0.2,H29<=0.3),300,IF(AND(H29>0.3),500,IF(H29>=1000,""''''')))))要算到H36 可不可以设计一个简便的公式一个个变化H29太麻烦了展开

 我来答

1个回答

#热议# 网上掀起『练心眼子』风潮，真的能提高情商吗？

易檬车牌识别停车场
2012-05-19

知道答主

回答量：5

采纳率：0%

帮助的人：4576

我也去答题访问个人页

关注

展开全部

=IF($H$29<=0.1,0,IF(AND($H$29>0.1,H29<=0.2),100,IF(AND($H$29>0.2,H29<=0.3),300,IF(AND($H$29>0.3),500,IF($H$29>=1000,""''''')))))

已赞过 已踩过<

评论收起

推荐律师服务：若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询

=IF(H29<=0.1,0,IF(AND(H29>0.1,H29<=0.2),100,IF(AND(H29>0.2,H29<=0.3),300,IF(AND(H29>0.3),500,IF(H29> 10

为你推荐：