Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Conditions in a Formula | Excel Discussion (Misc queries) | |||
Nesting conditions together. | Excel Discussion (Misc queries) | |||
multiple conditions formula | Excel Worksheet Functions | |||
Nesting more than 7 conditions? | Excel Worksheet Functions | |||
Nesting If Statement with "AND", "OR" conditions | Excel Worksheet Functions |