Put in B2 and drag down
=IF(A2=SMALL($A$1:A1,1)*1.2,"Yes","NO")

Vijay


"vt2wake2vt" wrote:

DATA (in colum A cells 1-5):
14
11
12
16
8

ISSUE: How can I automatically populate YES or NO into column B beside each
data point in column A based on the following scenario. I need to know if
the data point in column A is = 20% higher than all of the prior data points
would also work. So B1 would be N/A because there is no prior data point for
A1, B2 would be yes if the data point in A2 is = 20% higher than the data
point A1, B3 would be yes if the data point in A3 is 20% higher than either
A1 OR A2, B4 would be yes if the data point in A4 is 20% higher than either
A1 A2 or A3, etc. Thoughts?