14 Replies Latest reply on Mar 16, 2012 12:56 PM by SeamusDoone

    IF function not working correctly

    SeamusDoone

      Title

      IF function not working correctly

      Post

      Hello, 

      I have an IF function that is revelaing the results of a trend for invoices in consecutive years.  I want the result to either be a (+) or a (-).

      I basically have 3 years in a row: Year1, Year2, Year3

      My current equation looks like this =IF(Year1<Year2<Year3, "(+)", "(-)")

      I want it to be an ascending equation where if 2009 is more than 2010 or 2011 then a negative trend is the result

      if 2009 is less than 2010 which is less than 2011 then I want it to be a (+) trend

      if 2009 is less than 2010 but 2010 is more than 2011 I want a (-) trend

      What does the equation have to look like if thats possible?