software

Hi,

I'm using this formula -

=COUNTIF(Registers!E57:GB57,quot;üquot;)/COUNTA(Registers!E57:GB57)*100

Is there a way of developing it so that if there is no data to be
calculated or if the answer is 0 then the cell is left blank. At the
moment it displays #DIV/0!

Cheers,

Mark.--
mevetts------------------------------------------------------------------------
mevetts's Profile: www.excelforum.com/member.php...oamp;userid=29130
View this thread: www.excelforum.com/showthread...hreadid=499203=if(COUNTA(Registers!E57:GB57)*100gt;0,COUNTIF(Regis ters!E57:GB57,quot;üquot;)/COUNTA(Registers!E57:GB57)*100,quot;quot;)quot;mevettsquot; gt; wrote in
message ...
gt;
gt; Hi,
gt;
gt; I'm using this formula -
gt;
gt; =COUNTIF(Registers!E57:GB57,quot;üquot;)/COUNTA(Registers!E57:GB57)*100
gt;
gt; Is there a way of developing it so that if there is no data to be
gt; calculated or if the answer is 0 then the cell is left blank. At the
gt; moment it displays #DIV/0!
gt;
gt; Cheers,
gt;
gt; Mark.
gt;
gt;
gt; --
gt; mevetts
gt;
gt;
gt; ------------------------------------------------------------------------
gt; mevetts's Profile:
gt; www.excelforum.com/member.php...oamp;userid=29130
gt; View this thread: www.excelforum.com/showthread...hreadid=499203
gt;
Since you said that you *didn't* want to see a zero, as well as a #DIV/0
error, try this:

=IF(COUNTIF(E57:GB57,quot;uquot;),COUNTIF(E57:GB57,quot;uquot;)/COUNTA(E57:GB57)*100,quot;quot;)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

quot;mevettsquot; gt; wrote in
message ...
gt;
gt; Hi,
gt;
gt; I'm using this formula -
gt;
gt; =COUNTIF(Registers!E57:GB57,quot;üquot;)/COUNTA(Registers!E57:GB57)*100
gt;
gt; Is there a way of developing it so that if there is no data to be
gt; calculated or if the answer is 0 then the cell is left blank. At the
gt; moment it displays #DIV/0!
gt;
gt; Cheers,
gt;
gt; Mark.
gt;
gt;
gt; --
gt; mevetts
gt;
gt;
gt; ------------------------------------------------------------------------
gt; mevetts's Profile:
www.excelforum.com/member.php...oamp;userid=29130
gt; View this thread: www.excelforum.com/showthread...hreadid=499203
gt;
Thanks people, much appreciated.--
mevetts------------------------------------------------------------------------
mevetts's Profile: www.excelforum.com/member.php...oamp;userid=29130
View this thread: www.excelforum.com/showthread...hreadid=499203And we appreciate the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
quot;mevettsquot; gt; wrote in
message ...
gt;
gt; Thanks people, much appreciated.
gt;
gt;
gt; --
gt; mevetts
gt;
gt;
gt; ------------------------------------------------------------------------
gt; mevetts's Profile:
www.excelforum.com/member.php...oamp;userid=29130
gt; View this thread: www.excelforum.com/showthread...hreadid=499203
gt;