IF function not working correctly
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?