I have a worksheet:
Column B is a value for year 2002
Column C is a value for year 2001
Column D is a percentage of increase or decrease between the two years.
If both B & C are equal to zero I want
zero in column D, otherwise I want the percent of increase or decrease versus year 2001. In no instance to I want a Divide by Zero error.
thanks,
This message was edited by hal1543 on 2002-05-02 06:54
Column B is a value for year 2002
Column C is a value for year 2001
Column D is a percentage of increase or decrease between the two years.
If both B & C are equal to zero I want
zero in column D, otherwise I want the percent of increase or decrease versus year 2001. In no instance to I want a Divide by Zero error.
thanks,
This message was edited by hal1543 on 2002-05-02 06:54