"IF" statement displays "False" instead of "0"

[Al]

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?

 

[Frank Kabel]

Hi
you may post the used IF formula. Probably the FALSE parameter is
missing