Posts by shanethompson

    I have 12 months of data - cells E7 to P7, in cell Q7 I want to place an arrow (Up, Down Sideways) based on the trend for the previous 12 months

    Looking for the calculation and how to format it, to achieve the result


    [COLOR=blue !important][COLOR=blue !important]Hi [COLOR=blue !important]All[/COLOR][/COLOR][/COLOR]
    I have a spread sheet that is looking at performance by month
    What I would like to do is have a calculation in one cell that looks at the tend to see if the measure is improving or not

    How my sheet is set up

    In row 8 from Column "E" to "Q" I have the names of months Aug 2015 to Aug 2016
    In row 9 under each of the months I enter a performance figure

    In Row 9 Column "S" I want a calculation that looks at the data entered so far and works out a trend placing an arrow for 3 different scenarios Performance Improving = Arrow pointing up, Or Performance staying the same = Arrow sideways or Performance declining arrow pointing down (I would use the starting data as per the cell E8)
    with this calculation I need it to realise if there is blank data then it doesn't count this as Zero

    Can someone please help

    Thanks [/INDENT]