Losing the #DIV/0!
 

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

Losing the #DIV/0!
 

=if(COUNTA(Registers!E57:GB57)*1000,COUNTIF(Regis ters!E57:GB57,"ü")/COUNTA(Registers!E57:GB57)*100,"")


"mevetts" wrote in
message ...

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

Losing the #DIV/0!
 

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" wrote in
message ...

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

Losing the #DIV/0!
 

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

Losing the #DIV/0!
 

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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"mevetts" wrote in
message ...

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