=IF(AND(Q4="N/A",R4="大于一年"),"是",IF($Q$1-Q4>365,"是","否")) EXCEL中的公式啊 求指教,错在哪里

来源：学生作业帮助网 编辑：六六作业网 时间：2024/05/18 11:21:25
=IF(AND(Q4="N/A",R4="大于一年"),"是",IF($Q$1-Q4>365,"是","否"))EXCEL中的公式啊求指教,错在哪里=IF(AND(Q4="N/A",R4="大于一年"

=IF(AND(Q4="N/A",R4="大于一年"),"是",IF($Q$1-Q4>365,"是","否")) EXCEL中的公式啊 求指教,错在哪里
=IF(AND(Q4="N/A",R4="大于一年"),"是",IF($Q$1-Q4>365,"是","否")) EXCEL中的公式啊 求指教,错在哪里

=IF(AND(Q4="N/A",R4="大于一年"),"是",IF($Q$1-Q4>365,"是","否")) EXCEL中的公式啊 求指教,错在哪里
=IF(OR(ISNA(Q4),R4="大于一年"),"是",IF($Q$1-Q4>365,"是","否"))