Without knowing more about the conditions and results, I'd suggest using
VLOOKUP from a table of corresponding values.


J K
1 YEAR VALUE
2 2005 value1
3 2006 value2
....
20 2024 value20



=VLOOKUP(YEAR(A1), J:K, 2, FALSE)



In article ,
sfs wrote:

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?