=(YEAR(TODAY())-2004)*some_value
as a starting guess, a bit light on detail
--
HTH
RP
(remove nothere from the email address if mailing direct)
"sfs" wrote in message
...
I have a group of mutually exclusive If statements that I want to exercise
in
a cell. Specifically, if the year is 2005 I want to return one value, if
the
year is 2006, I want to return another, etc. Can't see how to do this
simply
without creating a giant nesting of If statements. Anyone have
suggestions?
|