I have the following data

_Year_ _Expense_
1994 200
1995 250
1996 300

in your new field populated by the IF statement use something like..
=if(<year is < 1995,"Prior","Yr"&<year)
Then the year values will all be strings and "P" comes before "Y"

or create a pivot table showing all years, select 1994 and 1995 with
the mouse, right-click and select Group and then change the created
label to "1995 and earlier" or equivalent.


--
steven1001
------------------------------------------------------------------------
steven1001's Profile: http://www.excelforum.com/member.php...o&userid=30757
View this thread: http://www.excelforum.com/showthread...hreadid=574344