请帮忙看看下面的函数写的,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/11/16 01:53:10
请帮忙看看下面的函数写的,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
首先小于等于得写成<=
其次既然你要乘一个百分比,就直接写1.5就行了,不能写150%
没逻辑,没法改,不如你直接把标准写出来,别人写一个给你。
50-70 -10
??? -15