Thread: #DIV/0!
View Single Post
  #2  
Old December 26th, 2007, 05:54 PM posted to microsoft.public.excel.worksheet.functions
joeu2004
external usenet poster
 
Posts: 1,748
Default #DIV/0!

On Dec 26, 9:48*am, PAL wrote:
I have a table that is performing a lot of calculations. *Because there is no
data yet to complete the formula I get the "#DIV/0!" error. *Is there a way
to hide this until there is a data.


=if(A1="", "", B1/A1)