G
Guest
Hi All,
Question about an un-expected return value... I built some IF statements in an excel spreadsheet. They are suppossed to return a 1 (if true) or 0 (if false).
In about 90% of the spreadsheet (couple of thousand data points) the statements DO display a "0" but every here or there, there is a cluster of "False" instead of "0." I have checked the cell format of the offending "False" and it is number as in the rest of the spreadsheet...?
I need all of the values to display as 0 or 1.
Any suggestions?
Question about an un-expected return value... I built some IF statements in an excel spreadsheet. They are suppossed to return a 1 (if true) or 0 (if false).
In about 90% of the spreadsheet (couple of thousand data points) the statements DO display a "0" but every here or there, there is a cluster of "False" instead of "0." I have checked the cell format of the offending "False" and it is number as in the rest of the spreadsheet...?
I need all of the values to display as 0 or 1.
Any suggestions?