AnsweredAssumed Answered

IF function not working correctly

Question asked by SeamusDoone on Mar 16, 2012
Latest reply on Mar 16, 2012 by 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?

Outcomes