Thread: #DIV/0!
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
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)