having problems with a multiple conditions nesting formula

[vt2wake2vt]

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?

 

[T. Valko]

Not sure I understand.

See if this does what you want.

Enter this formula in B2 and copy down to B5:

=IF(SUMPRODUCT(--(A2>=1.2*A$1:A1)),"Yes","No")

 

[Vijay]

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

 

[Vijay]

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

Vijay