使用IF语句在计算列上的语法错误 [英] Syntax Error on Calculated Column using an IF statement

问题描述

使用以下if语句时出现语法错误:

I get a syntax error when I use this if statement:

= IF([Expire]&=; [NOW()]，已过期"，有效)

=IF([Expire]<=[NOW()],"Expired", Active)

如果"Expire"为"Expire"，则我试图获取计算列以填充Expired.列的日期小于今天的当前日期.但是，如果日期大于今天，我希望它在计算列中填充活动".

I am trying to get the calculated column to populate Expired if the "Expire" column's date is less than todays current date. However if the date is greater than today I want it to populate Active in the calculated column.

如何解决此问题?

推荐答案

= IF([Expire]&== TODAY()，"Expired"，"Active")

=IF([Expire]<=TODAY(),"Expired", "Active")

??

这篇关于使用IF语句在计算列上的语法错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！