software

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),quot;quot;,(B7-B6)/ABS(B6))

and

=IF((B8-B7)/ABS(B7)=0,quot;quot;)

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

Hi Cyrus,

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

gt; =IF(ISERROR((B7-B6)/ABS(B6)),quot;quot;,(B7-B6)/ABS(B6))

hth
Giz

quot;Cyrusquot; wrote:

gt; I'm creating a worksheet where I want to carry the formula down the sheet,
gt; eventhough cells are blank. I keep getting error values. I understand why
gt; the error values, but I do not want them to display.
gt;
gt; My formula is: =(B6-B5)/ABS(B5)
gt;
gt; If tired:
gt;
gt; =IF(ISERROR(B7-B6)/ABS(B6),quot;quot;,(B7-B6)/ABS(B6))
gt;
gt; and
gt;
gt; =IF((B8-B7)/ABS(B7)=0,quot;quot;)
gt;
gt; but #DIV/0! keeps displaying.
gt;
gt; Is there an option or conditional format that will give me the option to not
gt; display error values? I have to create worksheets for several other formulas
gt; and I do not want the error values to display when cells are empty or when
gt; dividing by zero.
gt;
gt; Thanks,
gt;
gt; Cyrus
gt;
gt;
gt;

IT WORKED!!!! GREAT THANKS!!!

quot;Gizmo63quot; wrote:

gt; Hi Cyrus,
gt;
gt; Very Close, you just need to sort out your brackets.
gt;
gt; gt; =IF(ISERROR((B7-B6)/ABS(B6)),quot;quot;,(B7-B6)/ABS(B6))
gt;
gt; hth
gt; Giz
gt;
gt; quot;Cyrusquot; wrote:
gt;
gt; gt; I'm creating a worksheet where I want to carry the formula down the sheet,
gt; gt; eventhough cells are blank. I keep getting error values. I understand why
gt; gt; the error values, but I do not want them to display.
gt; gt;
gt; gt; My formula is: =(B6-B5)/ABS(B5)
gt; gt;
gt; gt; If tired:
gt; gt;
gt; gt; =IF(ISERROR(B7-B6)/ABS(B6),quot;quot;,(B7-B6)/ABS(B6))
gt; gt;
gt; gt; and
gt; gt;
gt; gt; =IF((B8-B7)/ABS(B7)=0,quot;quot;)
gt; gt;
gt; gt; but #DIV/0! keeps displaying.
gt; gt;
gt; gt; Is there an option or conditional format that will give me the option to not
gt; gt; display error values? I have to create worksheets for several other formulas
gt; gt; and I do not want the error values to display when cells are empty or when
gt; gt; dividing by zero.
gt; gt;
gt; gt; Thanks,
gt; gt;
gt; gt; Cyrus
gt; gt;
gt; gt;
gt; gt;