It should be noted that:
- Arguments must evaluate to logical values, as TRUE or FALSE, or the arguments must be arrays or references that contain logical values.
- If an array or reference argument contains text or empty cells, those values are ignored
- If the specified range does not contain logical values, the Y function returns the #VALUE! error values.
Please, see my example below: