# Calculated column for IF not working

I have created a calculated column to see if the target has been met. I have tried different combinations of IF formulas. Am I missing something? Thank you

``````=IF([Response date]=0,"Not met",IF([Days to complete]>=[Estimated response (days)],"Not met",IF([Days to respond]<=[Estimated response (days)],"Met")))
``````
``````=IF([RESPONSE DATE]=0,"NOT MET",IF([DAYS TO COMPLETE]>=[ESTIMATED RESPONSE (DAYS)],"NOT MET","MET"))
``````

For the first formula, the last if statement, `IF([Days to respond]<=[Estimated response (days)],"Met")` , you only provide one branch. The syntex of IF function shall be like

``````IF(logical_test,value_if_true,value_if_false)
``````

And for the second formula it seems fine and works in my end

Are you using number column for both days column?

Update: Column settings and result

• I have checked that the columns are set to number. I fixed the first formula, that didn't work. I copied the second formula, that didn't work. I deleted the calculated column and re-added it, and it's still not working. Both formulas are still not working. Mar 25 at 23:26
• I tried a different formula `=IF([Days to complete]>=[Estimated response (days)],"NOT MET","MET")`. This is the !result. Mar 26 at 0:00
• @doughnut, then it may be better for you to check the column settings, like column type. Because it seems what ever the value is, the condition is always false. May be one of the column is in fact a single text column Mar 26 at 1:55
• These are the settings for the fields. Calculated column, Estimated response date, Days to respond, formula, and output. I'm not sure what else I can try. Mar 26 at 2:11
• @doughnut, It seems I find the root cause. The formula in Estimated Response returns a wrong value. You shall use 5 instead of "5" as the return value (so as "10"). "5" will be treated as a string instead of a number even you set the return value as number. Mar 26 at 2:35