Losing the #DIV/0!

[mevetts]

Hi,

I'm using this formula -

=COUNTIF(Registers!E57:GB57,"ü")/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.

[Barb Reinhardt]

=if(COUNTA(Registers!E57:GB57)*100>0,COUNTIF(Registers!E57:GB57,"ü")/COUNTA(Registers!E57:GB57)*100,"")


"mevetts" <[email protected]> wrote in
message news:[email protected]...
>
> Hi,
>
> I'm using this formula -
>
> =COUNTIF(Registers!E57:GB57,"ü")/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:
> http://www.excelforum.com/member.php...o&userid=29130
> View this thread: http://www.excelforum.com/showthread...hreadid=499203
>

[Ragdyer]

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,"u"),COUNTIF(E57:GB57,"u")/COUNTA(E57:GB57)*100,"")
--
HTH,

RD

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

"mevetts" <[email protected]> wrote in
message news:[email protected]...
>
> Hi,
>
> I'm using this formula -
>
> =COUNTIF(Registers!E57:GB57,"ü")/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:
http://www.excelforum.com/member.php...o&userid=29130
> View this thread: http://www.excelforum.com/showthread...hreadid=499203
>

[mevetts]

Thanks people, much appreciated.

[Ragdyer]

And we appreciate the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"mevetts" <[email protected]> wrote in
message news:[email protected]...
>
> Thanks people, much appreciated.
>
>
> --
> mevetts
>
>
> ------------------------------------------------------------------------
> mevetts's Profile:
http://www.excelforum.com/member.php...o&userid=29130
> View this thread: http://www.excelforum.com/showthread...hreadid=499203
>