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. The percent change from 300 to 200 is -.33% (200-300/300). The percent change from 200 to 50 is -.75% (50-200/200). The percent change from 50 to 150 is +2.0% (150-50/50). If every year since the max experienced a percent decrease, return a 1. If every year since the max experienced a percent increase, return a 2. In all other cases, e.g., a decrease in one year, an increase in the next (as in this example), return a 3. If it's not possible to use a formula for this, a macro would be fine. I'm just stumped as to how to get Excel to calculate this. It needs to find the peak, and then determine whether all subsequent values are constantly decreasing, increasing, or in flux. Thanks for any suggestions. -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
