Using iserror in formula
 

Hi

I am currently using Excel 2003 and need help with a formula.

In my spreadsheet, I have the following:

Cur Wk Last Wk Index Change
50,108 48,928 102 —„–º
3,912 3,539 111 –²
2,341 0 0 –¼
0 2,341 0 –¼

I'm using the following calculation: IF(ISERROR(B14/C14),0,B14/C14*100)
The result is used to demonstrate change -- i.e. there is no change between
column A and B, there is a 5% or more change, there is a 5% or less change.

I can't seem to get the formula to work with 0. Row 1 and 2 are correct.
For Row 3, I want to indicate that there is an increase from last week but
forcing a zero does not work.

In the example above

Using iserror in formula
 

Your data is difficult to follow. You say "change between Column A and B", but
your formula references Column B and C. Also, what is the formula that displays
the change indicators (the up/down/sideways arrows)?

In your change indicator formula, you will be testing for an error (division by
zero). When it's true, just display the up arrow.

--
Regards,
Fred


"forest8" wrote in message
...
Hi

I am currently using Excel 2003 and need help with a formula.

In my spreadsheet, I have the following:

Cur Wk Last Wk Index Change
50,108 48,928 102 ??
3,912 3,539 111 ?
2,341 0 0 ?
0 2,341 0 ?

I'm using the following calculation: IF(ISERROR(B14/C14),0,B14/C14*100)
The result is used to demonstrate change -- i.e. there is no change between
column A and B, there is a 5% or more change, there is a 5% or less change.

I can't seem to get the formula to work with 0. Row 1 and 2 are correct.
For Row 3, I want to indicate that there is an increase from last week but
forcing a zero does not work.

In the example above