Forum Discussion
Solved
excell issue
I have set up a column with each cell being filled with 1 or 0 depending on a condition. This works and I have a column populated with 1 and 0 depending on the condition being realized or not. I th...
it is had without the actual sheet or even the specific formulas you use. One wild guess:
did you use something like
=IF( [condition], "1", "0")?
If so remove the "" around the numbers 1 and 0
Did you perhaps use formulas that return "0" and "1"? If so, those are text values - change them to 0 and 1.
Otherwise: Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?