AND and OR (and logical operators, if enabled) return NaN if any value is NaN #23
Description
AND(TRUE, NA(), TRUE)
OR(TRUE, NA(), FALSE)
5 & NA
5 | NA
Should all result in NaN the way Excel does.
{{ message }}
AND(TRUE, NA(), TRUE)
OR(TRUE, NA(), FALSE)
5 & NA
5 | NA
Should all result in NaN the way Excel does.