Thread: Is there a way of not displaying 'Div0!' in a cell?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dana DeLouis Dana DeLouis is offline
external usenet poster
  
Posts: 947
Default Is there a way of not displaying 'Div0!' in a cell?
In Excel 2007, perhaps:

=IFERROR(3.14/A1,"")

Returns blank if A1 evaluates to zero.

--
Dana DeLouis
Windows XP & Excel 2007


"Rani" wrote in message
...



Reply With QuoteReply With Quote