Forum Discussion
Solved
IF formula error message "The formula contains a syntax error."
Hi all. I'm trying a very simple IF formula in a calculated column at my data list. =IF([Monitorar]=0;"0";"1") I tried replacing the ; by , and not solved. I also tried replacing IF b...
The column Monitorar is a date/time field, but the calculated column is a number field and should accept either 0 or 1. I wasn't sure that a date could equal 0, but I tested this and it works fine:
=IF([Due Date]=0,0,1)So today I learned a empty date field equals 0. Good stuff!
The column Monitorar is a date/time field, but the calculated column is a number field and should accept either 0 or 1. I wasn't sure that a date could equal 0, but I tested this and it works fine:
=IF([Due Date]=0,0,1)
So today I learned a empty date field equals 0. Good stuff!
Thanks to all for your replies. Obviouslý I forgot that numbers don't need quotes. PamDeGraffenreid, your solution worked.