having problems with a multiple conditions nesting formula
 

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?

having problems with a multiple conditions nesting formula
 

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

--
Biff
Microsoft Excel MVP


"vt2wake2vt" wrote in message
...
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?

having problems with a multiple conditions nesting formula
 

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


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

having problems with a multiple conditions nesting formula
 

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?