Question

EXCEL提示公式错误，请问一下这个错在哪？

？=IF(AND(TODAY()<I3+1095,J3="是"),"有效期",IF(AND(TODAY()>I3,J3="否"),"已过期",IF(AND(TODAY()<H3,J3="否","未到期"))))

Answer 1

=IF(AND(TODAY()<I3+1095,J3="是"),"有效期",IF(AND(TODAY()>I3,J3="否"),"已过期",IF(AND(TODAY()<H3,J3="否"),"未到期")))  这样应该就对了

=IF(AND(TODAY()<I3+1095,J3="是"),"有效期",IF(AND(TODAY()>I3,J3="否"),"已过期","未到期"))

Answer 2

在第三个IF语句中，AND中的“否”后面少了一个后括号，公式最后用三个后括号就行了（对应三个IF语句的三个前括号）

Answer 3

=IF(AND(TODAY()<I3+1095,J3="是"),"有效期",IF(AND(TODAY()>I3,J3="否"),"已过期",IF(AND(TODAY()<H3,J3="否"),"未到期","")))

是这样吧？

Answer 4

少了一组括号，改为：
？=IF(AND(TODAY()<（I3+1095）,J3="是"),"有效期",IF(AND(TODAY()>I3,J3="否"),"已过期",IF(AND(TODAY()<H3,J3="否","未到期"))))