tinyexpr-plusplus icon indicating copy to clipboard operation
tinyexpr-plusplus copied to clipboard

Published 20 hours ago • verified publisher icon Blake-Madden

AND and OR (and logical operators, if enabled) return NaN if any value is NaN

Open Blake-Madden opened this issue 6 months ago • 0 comments

AND(TRUE, NA(), TRUE) OR(TRUE, NA(), FALSE) 5 & NA 5 | NA

Should all result in NaN the way Excel does.

Blake-Madden avatar May 24 '25 11:05 Blake-Madden