View original (French)

EXCEL does not display #VALUE

Solved
filing45 Posted messages 35 Registration date   Status Membre -  
 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 réponses

Réponse 1 / 5
Oric1 Posted messages 747 Status Contributeur 410
 
=IF(ISERROR(D8/E8);"";D8/E8)

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

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


=IFERROR(D8/E8,"")

0
RemRem
 
Big thank you!!!
0