| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search column for value and return TRUE or FALSE | Excel Worksheet Functions | |||
| Can a function return a Null (blank ) value? Maybe a custom functi | Excel Worksheet Functions | |||
| How do I return True False | Excel Worksheet Functions | |||
| If Function true value in Red | Excel Worksheet Functions | |||
| Function to return colour of formatted cell | Excel Worksheet Functions | |||
Hybrid Mode
