怎么在电子表格中插入条件备注公式?
发布网友
发布时间:2022-06-08 00:36
我来回答
共1个回答
热心网友
时间:2023-11-01 03:48
A3单元格输入公式
=IF(AND(A1=8,A2=5),"合格",IF(AND(A1>8,A1<10,A2>3,A2<5),"基本合格",IF(AND(A1>10,A2<3),"不合格","")))
或
=IF((A1=8)*(A2=5),"合格",IF((A1>8)*(A1<10)*(A2>3)*(A2<5),"基本合格",IF((A1>10)*(A2<3),"不合格","")))
=IF((A1=8)*(A2=5),"合格",IF(A1<10,IF((A1>8)*(A2>3)*(A2<5),"基本合格",""),IF(A2<3,"不合格","")))