Forum Discussion
IF statement set numeric value
I'm having a problem with a if statement. It's seems simple but not or I'm making a mistake. 1 field (whole number) : Response tag The new column is Status_SLA_Response = IF(VALUE([Respons...
Anonymous not ideal but can you +0 to the end of it and see if that fixes it?
Yes, it shows the right result but when a click on the Entre key just after the formula, it becomes wrong also.
It seems to be a problem with the IF statement because only the first <value_if_true> is displayed.
If I change to IF([Response Tag]<0,1,0), I get ones and blanks.
With IF([Response Tag]<0,0,1), I get zeros and blanks.
Anonymous not ideal but can you +0 to the end of it and see if that fixes it?