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

1. ## 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)}???

2. ## Re: 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" <TetsuyaOguma@discussions.microsoft.com> wrote in message
news:CFE7450E-8AB4-4A41-9B5C-4BF7A10D1CDD@microsoft.com...
> 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)}???
>

3. ## Re: 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

"Biff" wrote:

> Hi!
>
> One way:
>
> =COUNT(A1:A10)=COUNTA(A1:A10)
>
> Biff
>
> "Tetsuya Oguma" <TetsuyaOguma@discussions.microsoft.com> wrote in message
> news:CFE7450E-8AB4-4A41-9B5C-4BF7A10D1CDD@microsoft.com...
> > 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)}???
> >

>
>
>

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1