请问这段函数代表什么意思=IF(AND(F5="1",G5>0.3),1.3,IF(AND(F5="1",G5>0.15),1.2,IF(AND(F5="1",G5>0.05),1.1,IF(G5>-0.05,1,IF(G5>-0.15,0.9,IF(G5>-0.25,0.8,IF(G5>-0.35,0.7,IF(G5>-0.45,0.6,0.5))))))))
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/18 18:52:23
![请问这段函数代表什么意思=IF(AND(F5=](/uploads/image/z/4815556-52-6.jpg?t=%E8%AF%B7%E9%97%AE%E8%BF%99%E6%AE%B5%E5%87%BD%E6%95%B0%E4%BB%A3%E8%A1%A8%E4%BB%80%E4%B9%88%E6%84%8F%E6%80%9D%3DIF%28AND%28F5%3D%221%22%2CG5%3E0.3%29%2C1.3%2CIF%28AND%28F5%3D%221%22%2CG5%3E0.15%29%2C1.2%2CIF%28AND%28F5%3D%221%22%2CG5%3E0.05%29%2C1.1%2CIF%28G5%3E-0.05%2C1%2CIF%28G5%3E-0.15%2C0.9%2CIF%28G5%3E-0.25%2C0.8%2CIF%28G5%3E-0.35%2C0.7%2CIF%28G5%3E-0.45%2C0.6%2C0.5%29%29%29%29%29%29%29%29)
请问这段函数代表什么意思=IF(AND(F5="1",G5>0.3),1.3,IF(AND(F5="1",G5>0.15),1.2,IF(AND(F5="1",G5>0.05),1.1,IF(G5>-0.05,1,IF(G5>-0.15,0.9,IF(G5>-0.25,0.8,IF(G5>-0.35,0.7,IF(G5>-0.45,0.6,0.5))))))))
请问这段函数代表什么意思
=IF(AND(F5="1",G5>0.3),1.3,IF(AND(F5="1",G5>0.15),1.2,IF(AND(F5="1",G5>0.05),1.1,IF(G5>-0.05,1,IF(G5>-0.15,0.9,IF(G5>-0.25,0.8,IF(G5>-0.35,0.7,IF(G5>-0.45,0.6,0.5))))))))
请问这段函数代表什么意思=IF(AND(F5="1",G5>0.3),1.3,IF(AND(F5="1",G5>0.15),1.2,IF(AND(F5="1",G5>0.05),1.1,IF(G5>-0.05,1,IF(G5>-0.15,0.9,IF(G5>-0.25,0.8,IF(G5>-0.35,0.7,IF(G5>-0.45,0.6,0.5))))))))
按你公式的本意解释
如果F5=“1”且G5>0.3,返回值为1.3,(请注意您的F5=“1”这个1是文本,不是数字,文本和数字是不相等的)否则,F5=“1”且G5>0.15而小于等于0.3时,返回1.2,如果F5=“1”,且G5>0.5且G5-0.5时,返回值1,当G5小于或等于-0.05且大于-0.15时,返回0.9,当G5小于等于-0.15且大于-0.25时,返回0.8,当G5小于等于-0.25且大于-0.35时返回0.7,当G5小于等于-0.35且大于-0.45时返回0.6,当G5小于等于-0.45时返回0.5
请注意,你的公式中F5的值是文本还是数值,如果是数值,请把所有F5=“1”改为F5=1
否则公式是会出错的.而且IF不能超过7层.