Menu

Challenge for a formula

Search this Thread

Prev

Previous Post

Next Post

Next

#5

Report Post

Posted to microsoft.public.excel.misc

Bob I

Bob I is offline

external usenet poster

Posts: 2,819

Default

Challenge for a formula

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.

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
challenge formula	Frances C[_2_]	Excel Worksheet Functions	4	October 4th 07 05:46 AM
PLEASE HELP!!! Formula Question (Here's a challenge) :)	William@Target[_2_]	Excel Worksheet Functions	2	May 11th 07 07:11 PM
SUMPRODUCT formula challenge	Mitchell	Excel Worksheet Functions	3	October 11th 06 01:02 PM
Can this formula be created - Challenge	Brento	Excel Discussion (Misc queries)	0	June 20th 06 10:31 PM
Challenge experts will LOVE!!, Can you get the formula??	Drummy	Excel Discussion (Misc queries)	0	May 25th 06 07:17 AM

All times are GMT +1. The time now is 05:19 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement