Function to return True/False if all are validated as True by ISNU

Tetsuya Oguma · Mar 15, 2006

Hi all,

A simple function question.

What is a function that returns Truse if all the selected cells are
validated as True by ISNUMBER function and False if any of them is False?
Something like {=ISNUMBER(A1:A10)}???

Thanks in advance.

Biff · Mar 15, 2006

Hi!

One way:

=COUNT(A1:A10)=COUNTA(A1:A10)

Biff

paul · Mar 15, 2006

=and() will return true if all are true,=or() will return true if one is true

Function to return True/False if all are validated as True by ISNU

Tetsuya Oguma

Biff

paul