View original (French)

EXCEL hide #VALUE!

Solved
Annabelle30 Posted messages 6 Status Member -  
 Tulleb -
Hello everyone,

I created a table with formulas but since it is not filled yet, there are cells displaying #VALUE! and I would like to get rid of them.

I know it's a topic that has already been addressed, and I've tried several solutions without much success. So, I'm sharing the link below so you can take a look at the file I created.

https://www.cjoint.com/?BFvpvwMWAsb

config>Windows 7 / Internet Explorer 9.0</config>

4 answers

  1.
    pijaku Posted messages 13513 Registration date   Status Moderator Last intervention   2 773
     
    Hello,

    The cells returning #value contain formulas.

    Let’s assume your cell A1 contains a formula returning #value and that this formula is: =MYFORMULA(Z1)

    You can replace this formula in cell A1 with:
    =IF(ISERROR(MYFORMULA(Z1),"",MYFORMULA(Z1))

    Okay, it’s not a good solution, but hiding errors is very rarely (if ever) a good solution!
    --
    Best regards,
    Franck P
    4
    1. Tulleb
       

      =IF(ISERROR(MYFORMULA(Z1));"";MYFORMULA(Z1))
      0