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

remove error value when formula exists for empty cells
 

Hi Cyrus,

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

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

hth
Giz

"Cyrus" wrote:

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

remove error value when formula exists for empty cells
 

IT WORKED!!!! GREAT THANKS!!!

"Gizmo63" wrote:

Hi Cyrus,

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

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

hth
Giz

"Cyrus" wrote:

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