View original (French)

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

Solved
zara70 -  
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 Contributor
    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