Hello,
I'm trying to replace the numeric values in a column with a string value but I'm coming up against multiple issues.
Basically my column (there actually 6 I'm trying to do the same thing to) has numeric values and what I want is to replace any numeric value above 0 with the same string value. So regardless of the number as long as its above 0 I want it to be that value. I've tried various combinations of IF formulas and converting the types back and fourth but I cant get it work.
The most obvious formula to me was:
IF [Column Name] >= 0 THEN "Word" ELSE "" ENDIF
But that wont work because the column was double and I'm asking it to populate with a string. I tried doing it so it would populate with a number and I would then convert the number to a string but for some reason it just ignored the 0s and populated all the fields.
So it was something like:
IF [Column Name] >= 0 THEN 1 ELSE 0 ENDIF
IF [Column Name] = "1" THEN "Word" ELSE "0" ENDIF
Any ideas?
Thank you
