Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mevetts
 
Posts: n/a
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Barb Reinhardt
 
Posts: n/a
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ragdyer
 
Posts: n/a
Default 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


  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mevetts
 
Posts: n/a
Default 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

  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ragdyer
 
Posts: n/a
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to sum cells and ignore the #div/0! 's ? Todd Excel Worksheet Functions 6 April 25th 10 12:31 AM
#DIV/0!.......how to get rid of it renold1958 Excel Discussion (Misc queries) 7 July 17th 05 05:43 PM
replace "#DIV/0!" error with blanks Mark B Excel Worksheet Functions 0 June 22nd 05 10:19 AM
# DIV/0! error in Excel Helpwanted Excel Discussion (Misc queries) 8 May 6th 05 09:31 PM
blank instead of DIV/0! bill gras Excel Discussion (Misc queries) 2 March 21st 05 02:43 PM


All times are GMT +1. The time now is 01:25 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"