having problems with a multiple conditions nesting formula

  • Thread starter Thread starter vt2wake2vt
  • Start date Start date
V

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?
 
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")
 
Back
Top