请帮忙看看下面的函数写的,IF(AND(B12>A12*115%,B12A12*150%,"10",IF(AND(B12A12*70%),"-5",IF(AND(B12≤A12*70%,B12≥A12*50%),"-10",IF(B12

来源:学生作业帮助网 编辑:作业帮 时间:2024/05/15 17:00:07

请帮忙看看下面的函数写的,IF(AND(B12>A12*115%,B12A12*150%,"10",IF(AND(B12A12*70%),"-5",IF(AND(B12≤A12*70%,B12≥A12*50%),"-10",IF(B12
请帮忙看看下面的函数写的,
IF(AND(B12>A12*115%,B12A12*150%,"10",IF(AND(B12A12*70%),"-5",IF(AND(B12≤A12*70%,B12≥A12*50%),"-10",IF(B12

请帮忙看看下面的函数写的,IF(AND(B12>A12*115%,B12A12*150%,"10",IF(AND(B12A12*70%),"-5",IF(AND(B12≤A12*70%,B12≥A12*50%),"-10",IF(B12
IF(AND(B12>A12*1.15,B12=A12*1.3,B12<=A12*1.5),"5",IF(B12>A12*1.5,"10",IF(AND(B12A12*0.7),"-5",IF(AND(B12<=A12*0.7,B12>=A12*0.5),"-10",IF(B12你写的真够乱的
首先小于等于得写成<=
其次既然你要乘一个百分比,就直接写1.5就行了,不能写150%

没逻辑,没法改,不如你直接把标准写出来,别人写一个给你。
50-70 -10
??? -15