# 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.

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

Can you provide an example of desired results?

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.

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

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?

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

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.

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

You could copy the formula from the post ...

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

Got it! Thank You SO MUCH!!!! A life saver!

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

You're welcome.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1