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!
=IF([Monitorar]=0, 0,1)
Try using commas and remove the quotes. I think a quotes are for text, and you can’t pass text into a number column. Let me know if that works.