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

来源：学生作业帮助网 编辑：作业帮 时间：2024/04/30 04:28:08
=IF(AND(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(AND(Q4="N/A",R4="大于一年"),"是",IF($Q$1-Q4>365,"是","否")) EXCEL中的公式啊 求指教,错在哪里
=IF(OR(ISNA(Q4),R4="大于一年"),"是",IF($Q$1-Q4>365,"是","否"))