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
If the "Condition" is a choice of two options.
="cell"="condition" ex. =A2="Text"
This will return true or false which will sum as 1 or 0.