remove error value when formula exists for empty cells

[Guest]

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

 

[Guest]

Hi Cyrus,

Very Close, you just need to sort out your brackets.

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

hth
Giz

 

[Guest]

IT WORKED!!!! GREAT THANKS!!!

Hi Cyrus,

Very Close, you just need to sort out your brackets.


hth
Giz