> you can NEVER return a "2" which represents:
> "If every year since the max experienced a percent increase"
Ah! Oops.
And thank you for the macro. I will try it out.
As for this:
> Second is somewhat of a "logic" issue:
> you really don't need to know what the PERCENT increase/decrease per ye
the code to fit.
Paul
----- Original Message
> From: 0 1
> To: MS EXCEL AND VBA MACROS
> Sent: Tue, November 16, 2010 6:35:44 PM
> Subject: $$Excel-Macros$$ Calculating direction of change across several cells
>
> I'm trying to return a value (1,2,or3) based on the pe
I'm trying to return a value (1,2,or3) based on the percent change in
values since a max value. For example, assume cells A1:E1 contain
these values:
200,300,200,50,150.
The values represent the number of widgets produced in year 1, year 2,
up to year 5.
The max value for this example is 300.
T
