Find % increase in an array

[PCRIDE]

Hi, I think this is simple. I have 6 months of data which is the variance from one month to the other. I need a formula that looks at all 6 cells and tells me if the % change is greater or less than 10%. I was thinking of using an IF(AND(MATCH then adding the >110% and <90% but wasn't sure if there is a better way.

 

[kweaver]

Are you looking at the month-to-month variance?

[TABLE="width: 384"]
<colgroup><col style="width:48pt" width="64" span="6"> </colgroup><tbody>[TR]
[TD="class: xl63, width: 64, align: right"]13144[/TD]
[TD="class: xl63, width: 64, align: right"]11256[/TD]
[TD="class: xl63, width: 64, align: right"]12485[/TD]
[TD="class: xl63, width: 64, align: right"]10585[/TD]
[TD="class: xl63, width: 64, align: right"]14597[/TD]
[TD="class: xl63, width: 64, align: right"]15000[/TD]
[/TR]
[TR]
[TD="class: xl63"] [/TD]
[TD="class: xl64, align: right"]-14.36%[/TD]
[TD="class: xl64, align: right"]10.92%[/TD]
[TD="class: xl64, align: right"]-15.22%[/TD]
[TD="class: xl64, align: right"]37.90%[/TD]
[TD="class: xl64, align: right"]2.76%[/TD]
[/TR]
</tbody>[/TABLE]

My B2 formula is filled across and is

=(B1-A1)/A1

 

[PCRIDE]

I have the variance. I'm building a trigger alert so when the average of the variance exceeds 10%, give me a 1. Does that make sense? I need to look at all the cells. Something that gives me the anomaly .

Let's say the variance in 6 months averages about 10% month to month, this would be the normal. If one month jumped to 80%, then the average would probably be 25% so I need something that looks at all of the cells.

 

[PCRIDE]

I was able to come up with a method.