View original (French)

How to replace a #div/0! with an empty cell

Solved
zara70 Posted messages 188 Status Membre -  
Vaucluse Posted messages 27336 Registration date   Status Contributeur Last intervention   -
Hello,

I'm creating a table in which some cells show #DIV/0! instead of an empty cell.

Is there a way to do this?

Thank you

Configuration: iPad / Safari 7.0

3 réponses

Réponse 1 / 3
Vaucluse Posted messages 27336 Registration date   Status Contributeur Last intervention   6 453
 
Hello
to adapt
instead of =A1/B1

write:
=IF(B1=0,"",A1/B1)

or from Excel 2007 onwards:
=IFERROR(A1/B1,"")
regards

--
To err is human, to persist is diabolical
3