Challenge for a formula

[HammerJoe]

Hi,

I have a small challenge for ya all.
I am looking for the simplest formula you can come up with.

Heres how it works:

Cell A1 contains number of days from 1 to 365.

Starting at 14% for day one I know that every four days the percentage
increases by one.
So from 1-4 I should get 14%, from 5-8 it should be 15%, 9-12 it would
be 16% and so on.

So if cell A1 has for ie, 7 then the result would be 15%.

I know that a table could be used to find the value, but I am looking
for the simplest one line formula that gives the result.

Are you up to the challenge?
have fun with it.

 

[Pete_UK]

Put this formula in B1

=0.13+INT((A1+3)/4)*0.01

and format the cell as percentage.

Not a very hard challenge !! <bg>

Hope this helps.

Pete

 

[Bob I]

=(INT((A1-1)/4)*.01)+.14

 

[HammerJoe]

=(INT((A1-1)/4)*.01)+.14

Thanks for playing.

Well I knew it possible, I just didnt think that it could be that
simple.
Great job.

 

[Bob I]

Thanks for playing.

Well I knew it possible, I just didnt think that it could be that
simple.
Great job.

You're welcome, you should hang around and see what the real pros here
turn out.