Thread: How Do You Hide a #DIVO! Return in a cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rpalmer4
 
Posts: n/a
Default How Do You Hide a #DIVO! Return in a cell
Ok, what is the formula to return a blank cell vs. a #DIVO! ? My formula
currently is =1-(C15/G15) however when C15 is 0 my return is #DIVO! I would
like for the cell to remain blank if the c15 cell is 0.
Reply With QuoteReply With Quote