+ Reply to Thread
Results 1 to 3 of 3

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

  1. #1
    Tetsuya Oguma
    Guest

    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.

  2. #2
    Biff
    Guest

    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" <[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.




  3. #3
    paul
    Guest

    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
    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.

    >
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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