this seems like a simple issue but cant seem to get the solution working. I have a column "AI" which is outputting numeric values 0 or 1 based on certain conditions in previous columns.
I want to take the output of the column and use an IF statement to either output a "Yes" or "No" string based on the 1 or 0.
=IF(AI3<0;"Yes";"No")
The problem is that the output is "No" for 0 but also "Yes" for 0. Any reason why 1 would not be triggering the "Yes"?