|
最佳回答 |
|
0
|
snrtuemcLv8专家互助发布于2024-11-20 14:17
|
if(E17<H17&&Q17>S17,"优秀",if(E17>H17&&Q17<S17,"告警", if(E17<H17&&Q17<S17,"正常",if(E17>H17&&Q17>S17,"正常","其他")))) |
|
|
|
|
最佳回答 |
|
0
|
豆豆小可爱Lv5中级互助发布于2024-11-20 14:18
|
IF(AND(E17<H17 , Q17>S17),"优秀",IF(AND(E17>H17 , Q17<S17),"告警",IF(AND(E17<H17 , Q17<S17), "正常",IF(AND(E17>H17 , Q17>S17), "正常","")))) |
|
|
|
|
最佳回答 |
|
0
|
zhenyu123Lv4见习互助发布于2024-11-20 14:18
|
if(and(E17<H17 , Q17>S17),"优秀",if(and(E17>H17 , Q17<S17),"告警",if(and(E17<H17 ,Q17<S17),"正常",if(and(E17>H17 , Q17>S17),"正常","")))) |
|
|
|
1min目标场景问卷
立即参与
