Combinbing 3 If statements isn't working

Hello. Need a hand here ...

Three formulas work independent of each other; but when I combine them, they don't yield the results, I'm thinking it's because I'm adding "AND" in the middle equation:

=IF(AF30<(DATE(YEAR(AQ1)+5,MONTH(AQ1),DAY(AQ1))),(AF30-(DATEVALUE("1/1/2017")))*V31)
=IF(AND(AF30>=((DATE(YEAR(AQ1)+5,MONTH(AQ1),DAY(AQ1)))),(AF30<=((DATE(YEAR(AQ1)+10,MONTH(AQ1),DAY(AQ1)))))),(AF30-(DATEVALUE("1/1/2017")))*V32)
=IF(AF30>((DATE(YEAR(AQ1)+10,MONTH(AQ1),DAY(AQ1)))),(AF30-(DATEVALUE("1/1/2017")))*V33)

I combine the Three by removing the end parenthesis then add a comma:

=ROUND(IF(AF30<(DATE(YEAR(AQ1)+5,MONTH(AQ1),DAY(AQ1))),(AF30-(DATEVALUE("1/1/2017")))*V31,(IF(AND(AF30>=((DATE(YEAR(AQ1)+5,MONTH(AQ1),DAY(AQ1)))),(AF30<=((DATE(YEAR(AQ1)+10,MONTH(AQ1),DAY(AQ1)))))),(AF30-(DATEVALUE("1/1/2017")))*V32),IF(AF30>((DATE(YEAR(AQ1)+10,MONTH(AQ1),DAY(AQ1)))),(AF30-(DATEVALUE("1/1/2017")))*V33))),0)

Yield is #VALUE now.

Trying to calculate daily accrual rate of vacation based upon a hire date(cell AQ1) vs current date (cell AF30), if over 5 years then daily accrual is 0.2, if over 10 years .3 if over 15 years .4 (which I have in cells V31, V32, V33)

I'm stuck .....

Hey that works! Thanks Special-K !!!!

That one works PJ! Thanks! But I don't want todays date to be auto-populated, I wanted that to be a user submitted date

One more

=(AF30-(DATEVALUE("1/1/2017")))*V31/2 yields the correct number value of 3.39714

when I add ROUND to it, it yields: 38084

=ROUND(AF30-(DATEVALUE("1/1/2017"))*V31/2,0)

it should Round to 3.0

WTF am I doing wrong ?!?!

Try

=ROUND((AF30-(DATEVALUE("1/1/2017")))*V31/2,0)

DUH.... Thanks !

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.