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