View original (French)

EXCEL does not display #VALUE

Solved
filing45 Posted messages 35 Registration date   Status Member -  
 RemRem -
Hello,
in the table cells, I don't want to display the message "#VALUE#" and leave it blank. I can't remember how to do that. Can you help me?
thank you
Configuration: Windows 2000 Internet Explorer 6.0

5 answers

  1.
    Oric1 Posted messages 747 Status Contributor 410
     
    =IF(ISERROR(D8/E8);"";D8/E8)

    --
    R. T. F. M.
    148
    1. Rhodan
       
      A big thank you,

      I had forgotten about that one. I really needed it.
      0
    2. Boupa
       
      Thank you for this helping hand.
      0
    3. Lifeae
       
      Great, thanks! :D
      0
    4. SEBAS
       


      =IFERROR(D8/E8,"")

      0
    5. RemRem
       
      Big thank you!!!
      0