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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Function to return True/False if all are validated as True by ISNU (https://www.excelbanter.com/excel-worksheet-functions/77372-function-return-true-false-if-all-validated-true-isnu.html)

Tetsuya Oguma

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

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

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

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.

paul

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.

All times are GMT +1. The time now is 08:18 PM.