having problems with a multiple conditions nesting formula

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?
 
T

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")
 
V

Vijay

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top