View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cyrus
 
Posts: n/a
Default remove error value when formula exists for empty cells

I'm creating a worksheet where I want to carry the formula down the sheet,
eventhough cells are blank. I keep getting error values. I understand why
the error values, but I do not want them to display.

My formula is: =(B6-B5)/ABS(B5)

If tired:

=IF(ISERROR(B7-B6)/ABS(B6),"",(B7-B6)/ABS(B6))

and

=IF((B8-B7)/ABS(B7)=0,"")

but #DIV/0! keeps displaying.

Is there an option or conditional format that will give me the option to not
display error values? I have to create worksheets for several other formulas
and I do not want the error values to display when cells are empty or when
dividing by zero.

Thanks,

Cyrus