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

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.

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

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




"JULESFAR" wrote in message
...
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.