Losing the #DIV/0!

  • Thread starter Thread starter mevetts
  • Start date Start date
M

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.
 
=if(COUNTA(Registers!E57:GB57)*100>0,COUNTIF(Registers!E57:GB57,"ü")/COUNTA(Registers!E57:GB57)*100,"")
 
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,"")
 
Back
Top