software

I am trying to set up an accrual formula for vacation days, what I am needing
is a formula that will accrue at different rates, for example, employee earns
10 days per year up to 2 years, after 2 years, earns additional 1 day per
year to a max of 15 days per year the formula I have is not working: I am
getting a quot;FALSEquot; result for the 2nd, 3rd and 4th variables - PLEASE HELP!
=IF(C5lt;2,0.833333333333333,IF(2lt;C5lt;3,0.91666666666 6667,
IF(3lt;C5lt;4,1.08333333333333,IF(4lt;C5lt;5,1.16666666666 667,IF(5lt;C5,1.25)))))

you can't do that. change you formula to this...

=IF(C5lt;2,0.833333333333333,IF(C5lt;3,0.9166666666666 67,IF(C5lt;4,1.08333333333333,IF(C5lt;5,1.166666666666 67,IF(5lt;C5,1.25)))))

this will work because if C is not less than 2, then you don't need to check
that again.

If you don't feel comfortable with that, you can use something like this...

=IF(AND(Xlt;A3,A3lt;Y),quot;do truequot;,quot;do falsequot;)

quot;GApreciousquot; wrote:

gt; I am trying to set up an accrual formula for vacation days, what I am needing
gt; is a formula that will accrue at different rates, for example, employee earns
gt; 10 days per year up to 2 years, after 2 years, earns additional 1 day per
gt; year to a max of 15 days per year the formula I have is not working: I am
gt; getting a quot;FALSEquot; result for the 2nd, 3rd and 4th variables - PLEASE HELP!
gt; =IF(C5lt;2,0.833333333333333,IF(2lt;C5lt;3,0.91666666666 6667,
gt; IF(3lt;C5lt;4,1.08333333333333,IF(4lt;C5lt;5,1.16666666666 667,IF(5lt;C5,1.25)))))

Thanks soooo much - you are a lifesaver

quot;Slothquot; wrote:

gt; you can't do that. change you formula to this...
gt;
gt; =IF(C5lt;2,0.833333333333333,IF(C5lt;3,0.9166666666666 67,IF(C5lt;4,1.08333333333333,IF(C5lt;5,1.166666666666 67,IF(5lt;C5,1.25)))))
gt;
gt; this will work because if C is not less than 2, then you don't need to check
gt; that again.
gt;
gt; If you don't feel comfortable with that, you can use something like this...
gt;
gt; =IF(AND(Xlt;A3,A3lt;Y),quot;do truequot;,quot;do falsequot;)
gt;
gt; quot;GApreciousquot; wrote:
gt;
gt; gt; I am trying to set up an accrual formula for vacation days, what I am needing
gt; gt; is a formula that will accrue at different rates, for example, employee earns
gt; gt; 10 days per year up to 2 years, after 2 years, earns additional 1 day per
gt; gt; year to a max of 15 days per year the formula I have is not working: I am
gt; gt; getting a quot;FALSEquot; result for the 2nd, 3rd and 4th variables - PLEASE HELP!
gt; gt; =IF(C5lt;2,0.833333333333333,IF(2lt;C5lt;3,0.91666666666 6667,
gt; gt; IF(3lt;C5lt;4,1.08333333333333,IF(4lt;C5lt;5,1.16666666666 667,IF(5lt;C5,1.25)))))



quot;Slothquot; wrote:

gt; you can't do that. change you formula to this...
gt;
gt; =IF(C5lt;2,0.833333333333333,IF(C5lt;3,0.9166666666666 67,IF(C5lt;4,1.08333333333333,IF(C5lt;5,1.166666666666 67,IF(5lt;C5,1.25)))))
gt;
gt; this will work because if C is not less than 2, then you don't need to check
gt; that again.
gt;
gt; If you don't feel comfortable with that, you can use something like this...
gt;
gt; =IF(AND(Xlt;A3,A3lt;Y),quot;do truequot;,quot;do falsequot;)
gt;
gt; quot;GApreciousquot; wrote:
gt;
gt; gt; I am trying to set up an accrual formula for vacation days, what I am needing
gt; gt; is a formula that will accrue at different rates, for example, employee earns
gt; gt; 10 days per year up to 2 years, after 2 years, earns additional 1 day per
gt; gt; year to a max of 15 days per year the formula I have is not working: I am
gt; gt; getting a quot;FALSEquot; result for the 2nd, 3rd and 4th variables - PLEASE HELP!
gt; gt; =IF(C5lt;2,0.833333333333333,IF(2lt;C5lt;3,0.91666666666 6667,
gt; gt; IF(3lt;C5lt;4,1.08333333333333,IF(4lt;C5lt;5,1.16666666666 667,IF(5lt;C5,1.25)))))

An additional idea to Sloth's excellent formula might be to factor out the
1/12th part.

=IF(C5lt;2,10,IF(C5lt;3,11,IF(C5lt;4,13,IF(C5lt;5,14,15))) )/12

--
HTH. :gt;)
Dana DeLouis
Windows XP, Office 2003quot;GApreciousquot; gt; wrote in message
...
gt; Thanks soooo much - you are a lifesaver
gt;
gt; quot;Slothquot; wrote:
gt;
gt;gt; you can't do that. change you formula to this...
gt;gt;
gt;gt; =IF(C5lt;2,0.833333333333333,IF(C5lt;3,0.9166666666666 67,IF(C5lt;4,1.08333333333333,IF(C5lt;5,1.166666666666 67,IF(5lt;C5,1.25)))))
gt;gt;
gt;gt; this will work because if C is not less than 2, then you don't need to
gt;gt; check
gt;gt; that again.
gt;gt;
gt;gt; If you don't feel comfortable with that, you can use something like
gt;gt; this...
gt;gt;
gt;gt; =IF(AND(Xlt;A3,A3lt;Y),quot;do truequot;,quot;do falsequot;)
gt;gt;
gt;gt; quot;GApreciousquot; wrote:
gt;gt;
gt;gt; gt; I am trying to set up an accrual formula for vacation days, what I am
gt;gt; gt; needing
gt;gt; gt; is a formula that will accrue at different rates, for example, employee
gt;gt; gt; earns
gt;gt; gt; 10 days per year up to 2 years, after 2 years, earns additional 1 day
gt;gt; gt; per
gt;gt; gt; year to a max of 15 days per year the formula I have is not working: I
gt;gt; gt; am
gt;gt; gt; getting a quot;FALSEquot; result for the 2nd, 3rd and 4th variables - PLEASE
gt;gt; gt; HELP!
gt;gt; gt; =IF(C5lt;2,0.833333333333333,IF(2lt;C5lt;3,0.91666666666 6667,
gt;gt; gt; IF(3lt;C5lt;4,1.08333333333333,IF(4lt;C5lt;5,1.16666666666 667,IF(5lt;C5,1.25)))))