View original (French)

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

Solved
zara70 Posted messages 188 Status Member -  
Vaucluse Posted messages 27336 Registration date   Status Contributor 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 answers

  1.
    Vaucluse Posted messages 27336 Registration date   Status Contributor 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