Thread: #VALUE & #DIV0
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tonyalt3 tonyalt3 is offline
external usenet poster
 
Posts: 20
Default #VALUE & #DIV0

I have entered several functions in my spreadsheet, however the cells
they are dependant on do not currently have data entered in them. Is
there a way to retain the function in the cell, yet not have it show
"#VALUE" or "#DIV0"?