About Us

puiuluipui

HI, WORKS GREAT!!

Thanks allot!

"dhstein" a scris:

Use the array formula:

=MIN(IF(H1:H12$A$1,(H1:H12)-$A$1,MAX(H1:H12)))+$A$1

Array formulas are entered with "CTRL + SHIFT + ENTER"

See : http://www.cpearson.com/excel/ArrayFormulas.aspx

"puiuluipui" wrote:

Hi, i need an code with 12 arguments.

=IF(A1<H1,H1,IF(A1<H2,H2,IF(A1<H3,H3,IF(A1<H4,H4,I F(A1<H5,H5,IF(A1<H6,H6,IF(A1<H7,H7,IF(A1<H8,H8)))) ))))

This code is not working with more than 8 arguments, and i need 12.
I tried =choose, but still not working.
Any ideea?

Thanks!

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
IF multiple arguments	[email protected]	Excel Worksheet Functions	2	March 18th 08 09:19 PM
Multiple Arguments	ijt	Excel Discussion (Misc queries)	3	November 20th 06 06:48 AM
sum with multiple arguments	hotelmasters	Excel Worksheet Functions	2	August 23rd 06 07:10 PM
Multiple Arguments	dansargeant	Excel Worksheet Functions	3	March 10th 06 08:06 AM
how do I count with multiple arguments	Chris G	Excel Worksheet Functions	1	February 1st 06 05:45 PM

Menu

About Us