#NÚM! and #DIV/0

[tomribeiropereira]

Hi, thanks for the attention!


When W66 and X66 are 0 the result is of Y66 is "" (blank cell) like:

Y66=IF(W66*X66=0,"",X66/(X66*6.3)*10)

Ok by now... But... Y66 is part of =MED(Y62;Y66) and the result of this when all those cells are (BLANK) is #NÚM!

How can i have BLANK CELLS too in this second part of the equation?



Also...

=(Z68/Z58)*100-100 when Z68 is Blank and Z58 is also blank the result is #DIV/0!



How can i get BLANK cell in those cases?



Thanks for the support

[NBVC]

Try:

=SE(SOMA(Y62,Y66);MED(Y62;Y66);"")

and

=SE(Z58=0;0;(Z68/Z58)*100-100)