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.
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.
Hi!
One way:
=COUNT(A1:A10)=COUNTA(A1:A10)
Biff
"Tetsuya Oguma" <[email protected]> wrote in message
news:[email protected]...
> 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.
=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" <[email protected]> wrote in message
> news:[email protected]...
> > 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.
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks