Hi,

I have a list of data in a named range called "List". In its simplest
form the data would be cell A1:A10 that may have either a 1 or a 0
entered.

Could somebody advise how I would create a conditional formula in say
cell C1 which will tell me if any of the cells in "List" are not equal
to Zero. Something like
=if(anyValueinRange"List"<0,"NotAllZero","AllZero ")

Thanks in advance

Paul

=IF(COUNTIF(liste,"<0")=0,"AllZero","NotAllZero")

HTH
--
AP

a écrit dans le message de
oups.com...
Hi,

I have a list of data in a named range called "List". In its simplest
form the data would be cell A1:A10 that may have either a 1 or a 0
entered.

Could somebody advise how I would create a conditional formula in say
cell C1 which will tell me if any of the cells in "List" are not equal
to Zero. Something like
=if(anyValueinRange"List"<0,"NotAllZero","AllZero ")

Thanks in advance

Paul

Blanks will NOT be counted as zeros:

=IF(COUNTIF(List,0)<ROWS(List),"not all zeros","all zeros")

HTH

" wrote:

Hi,

I have a list of data in a named range called "List". In its simplest
form the data would be cell A1:A10 that may have either a 1 or a 0
entered.

Could somebody advise how I would create a conditional formula in say
cell C1 which will tell me if any of the cells in "List" are not equal
to Zero. Something like
=if(anyValueinRange"List"<0,"NotAllZero","AllZero ")

Thanks in advance

Paul

if(sum(list)0,NotAllZero,AllZero)

Since cells contain only 0 or 1


--
carno
------------------------------------------------------------------------
carno's Profile: http://www.excelforum.com/member.php...o&userid=33633
View this thread: http://www.excelforum.com/showthread...hreadid=534065