Posted to microsoft.public.excel.misc

John

external usenet poster

Posts: 2,069

formula excel 2007

=F4*CHOOSE(MATCH(F4,{-1E+300,5,10,20,30,40}),12,13,7,6,5,4)

hi all can somebody include a static figure if f4 is less than 5 in the
formula above
thanks
mike

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
I need a formula for excel 2007	colwyn	Excel Discussion (Misc queries)	7	October 20th 08 04:30 PM
Excel 2007 formula help	STEVE THE PARTS GUY	Excel Worksheet Functions	1	August 21st 07 02:11 PM
excel 2007 formula	STEVE THE PARTS GUY	Excel Worksheet Functions	1	August 20th 07 02:20 PM
Excel 2007 Formula Display	Training Spec.	Excel Discussion (Misc queries)	5	April 5th 07 01:22 PM
Excel Formula, who will be age 55 by 12/31/2007 and 6/30/2009?	Containsmiles	Excel Worksheet Functions	2	May 17th 06 05:27 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us