Thread: #VALUE! in cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
datub datub is offline
external usenet poster
  
Posts: 1
Default #VALUE! in cell
My formula is =SUM(B8:C8)*G8 where either B8 or C8 will always =0. How do I
not get this value" #VALUE!" when the cells are not in use?
Reply With QuoteReply With Quote