Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to sum cells and ignore the #div/0! 's ? | Excel Worksheet Functions | |||
#DIV/0!.......how to get rid of it | Excel Discussion (Misc queries) | |||
replace "#DIV/0!" error with blanks | Excel Worksheet Functions | |||
# DIV/0! error in Excel | Excel Discussion (Misc queries) | |||
blank instead of DIV/0! | Excel Discussion (Misc queries) |