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