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

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

wrote in message
...
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. :)

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

wrote:

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

On Jan 16, 1:14*pm, Bob I wrote:
=(INT((A1-1)/4)*.01)+.14



wrote:
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.
Thanks for playing.

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


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. :)- Hide quoted text -

- Show quoted text -

wrote:

On Jan 16, 1:14 pm, Bob I wrote:

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



wrote:

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.

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.