Excel Functions

[Guest]

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?

 

[Bob Phillips]

=(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)

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?

 

[JE McGimpsey]

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)

 

[Morrigan]

VLOOKUP() is probably a better choice rather than using IF().