Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am trying to create an IF formula that returs POSITIVE, NEGATIVE, or STABLE
depending on the trend found in a data series. Does anybody know how can I evaluate a data series for a positive/negative/stable trend? For instance, I have the following data set: MONTH January,February,March,April SALES 100,200,300,100 If I use a chart to analyze this data, I can visually identify it is a positive trend. Can I get that simple answer using a formula, rather than a chart? Thank you! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Some Positive, Some Negative | Excel Worksheet Functions | |||
post positive sum as a negative? help! | Excel Worksheet Functions | |||
IF positive/If negative???? | Excel Worksheet Functions | |||
Formula to make Negative Values Positive & Positive Values Negative? | Excel Discussion (Misc queries) | |||
Sum is positive value or "0" value. Negative value equals "0" | Excel Worksheet Functions |