# Needing a formula to calculate increments of 0.10 every 6 days.

1. ## Needing a formula to calculate increments of 0.10 every 6 days.

Basically I'm calculating \$0.75 for 6 days then on the 7th day it changes to \$0.85 then 6 days later 7th day \$0.95 and I need it to do it for 365 days.

I've tried
=IF(MOD(ROWS(\$B\$1:B1), 6)=0.75,B1+0.1, B1)

and

=INT((ROW(B1)+0.1)/6)+0.1

and they work as they are supposed too, but my increments go from 0.75 to 1.75 to 2.75 and so on and the increments of 0.10 goes from 0.10 for 6 days to 1.10. But I need it to start out at 0, then 7th day .10, then 6 days 7th day .10 again.  Register To Reply

2. ## Re: Needing a formula to calculate increments of 0.10 every 6 days.

Can you provide an example of desired results?  Register To Reply

3. ## Re: Needing a formula to calculate increments of 0.10 every 6 days.

\$0.75
\$0.75
\$0.75
\$0.75
\$0.75
\$0.75
\$0.85
\$0.85
\$0.85
\$0.85
\$0.85
\$0.85
\$0.95
\$0.95
\$0.95
\$0.95
\$0.95
\$0.95
\$1.05
and so on for 365 days. I hope that's what you are asking for.  Register To Reply

4. ## Re: Needing a formula to calculate increments of 0.10 every 6 days.

 A B 1 Fee 2 0.75 A2: Input 3 0.75 A3: =A2 + 0.1 * (MOD(ROWS(A\$2:A3) - 1, 6) = 0) 4 0.75 5 0.75 6 0.75 7 0.75 8 0.85 9 0.85 10 0.85 11 0.85 12 0.85 13 0.85 14 0.95 15 0.95 16 0.95 17 0.95 18 0.95 19 0.95 20 1.05 21 1.05 22 1.05 23 1.05 24 1.05  Register To Reply

5. ## Re: Needing a formula to calculate increments of 0.10 every 6 days.

So if I type what you wrote on B3 and grab tail and run free it will continue to calculate all the way for 365 days?  Register To Reply

6. ## Re: Needing a formula to calculate increments of 0.10 every 6 days.

Or ...

 A B 1 Fee 2 0.75 A2: =0.75 + 0.1 * INT((ROWS(A\$2:A2) - 1) / 6) 3 0.75 4 0.75 5 0.75 6 0.75 7 0.75 8 0.85 9 0.85 10 0.85 11 0.85 12 0.85 13 0.85 14 0.95 15 0.95 16 0.95 17 0.95 18 0.95 19 0.95 20 1.05 21 1.05 22 1.05 23 1.05 24 1.05  Register To Reply

7. ## Re: Needing a formula to calculate increments of 0.10 every 6 days.

And now I can't get the function F4 to work (I'm on Mac) to add the \$ \$ to the formula.  Register To Reply

8. ## Re: Needing a formula to calculate increments of 0.10 every 6 days.

You could copy the formula from the post ...  Register To Reply

9. ## Re: Needing a formula to calculate increments of 0.10 every 6 days.

Got it! Thank You SO MUCH!!!! A life saver!  Register To Reply

10. ## Re: Needing a formula to calculate increments of 0.10 every 6 days.

You're welcome.  Register To Reply