Posted to microsoft.public.excel.misc

puiuluipui puiuluipui is offline

external usenet poster

Posts: 468

If, multiple arguments

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!

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
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

All times are GMT +1. The time now is 04:39 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us