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