Thread: #DIV/0!
View Single Post
  #6  
Old December 26th, 2007, 09:01 PM posted to microsoft.public.excel.worksheet.functions
Teethless mama
external usenet poster
  
Posts: 3,722
Default #DIV/0!
=IF(A1,B1/A1,"")


"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.