How do I make an IF statement have multiple TRUE answers?

[Guest]

I am trying to write a formula for giving employees a merit increase on the
year anniversary of their start date. I tried to write IF the current
date-start date=1,2,3, or 4, then multiply their current salary by the merit
%. The dates are formatted as 2007.01, 2006.08, etc. It will let me do it
if it =1, but not the other years. I am forecasting for the next 5 years.

 

[Chip Pearson]

Try using CHOOSE with DATEDIF. E.g.,

=CHOOSE(DATEDIF(A1,TODAY(),"y"),1,2,3,4,5,6)

where A1 is your start date and the 1,2,3,4,5,6 values are the
merit increases.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com