View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier
 
Posts: n/a
Default How to get a cell with a zero errorto show the cell as blank

Hi

Do you mean something like
=IF(ISERROR(your_formula),"",your_formula)

Substitute the formula you have that is giving the divide by zero error
for "your_formula"

--
Regards

Roger Govier


"jsunshine" wrote in message
...