software

Hi,

I have a list of data in a named range called quot;Listquot;. 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 quot;Listquot; are not equal
to Zero. Something like
=if(anyValueinRangequot;Listquot;lt;gt;0,quot;NotAllZeroquot;,quot;AllZero quot;)

Thanks in advance

Paul=IF(COUNTIF(liste,quot;lt;gt;0quot;)=0,quot;AllZeroquot;,quot;NotAllZeroquot;)

HTH
--
AP

gt; a écrit dans le message de oups.com...
gt; Hi,
gt;
gt; I have a list of data in a named range called quot;Listquot;. In its simplest
gt; form the data would be cell A1:A10 that may have either a 1 or a 0
gt; entered.
gt;
gt; Could somebody advise how I would create a conditional formula in say
gt; cell C1 which will tell me if any of the cells in quot;Listquot; are not equal
gt; to Zero. Something like
gt; =if(anyValueinRangequot;Listquot;lt;gt;0,quot;NotAllZeroquot;,quot;AllZero quot;)
gt;
gt; Thanks in advance
gt;
gt; Paul
gt;
Blanks will NOT be counted as zeros:

=IF(COUNTIF(List,0)lt;gt;ROWS(List),quot;not all zerosquot;,quot;all zerosquot;)

HTH

quot; wrote:

gt; Hi,
gt;
gt; I have a list of data in a named range called quot;Listquot;. In its simplest
gt; form the data would be cell A1:A10 that may have either a 1 or a 0
gt; entered.
gt;
gt; Could somebody advise how I would create a conditional formula in say
gt; cell C1 which will tell me if any of the cells in quot;Listquot; are not equal
gt; to Zero. Something like
gt; =if(anyValueinRangequot;Listquot;lt;gt;0,quot;NotAllZeroquot;,quot;AllZero quot;)
gt;
gt; Thanks in advance
gt;
gt; Paul
gt;
gt;


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

Since cells contain only 0 or 1--
carno
------------------------------------------------------------------------
carno's Profile: www.excelforum.com/member.php...oamp;userid=33633
View this thread: www.excelforum.com/showthread...hreadid=534065