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. :)