Function to return True/False if all are validated as True by
=and() will return true if all are true,=or() will return true if one is true
--
paul
remove nospam for email addy!
"Biff" wrote:
Hi!
One way:
=COUNT(A1:A10)=COUNTA(A1:A10)
Biff
"Tetsuya Oguma" wrote in message
...
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.
|