excel的if函数嵌套

来源：百度知道编辑：UC知道时间：2024/09/25 21:28:39

=IF(I103<=TODAY()-60,"试用期满”,IF(I103<=TODAY()-40,"试用期近",""))
I列是入职时间，但是输入后一直提示错误额。
请问这个函数有何错误啊

有一个引号打错了，复制下面的就行：
=IF(I103<=TODAY()-60,"试用期满",IF(I103<=TODAY()-40,"试用期近",""))
祝你成功！

<=符号函数是不认可的，改为：
=IF(or(I103<(TODAY()-60),I103=(TODAY()-60)),"试用期满”,IF(or(I103<(TODAY()-40),I103=(TODAY()-40)),"试用期近",""))