=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