Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Function too Large
The function below is a partial version of the correct one; I will exceed the
allowed characters for the field (too many arguments). I notice I am using different arguments which could be combined as a range: IF(C16=5:7 for the same results, in other words 5, 6 & 7 all = E20 as a result. =IF(C16=5,E20,IF(C16=6,E20,IF(C16=7,E20,IF(C16=8,E 21,IF(C16=9,E21,IF(C16=10,E22,IF(C16=11,E22,IF(C16 11,E23,0)))))))) How can I build this function combining criteria as a range for a common result? -- Thank you, Trying Hard |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Function too Large
This could replace what you have so far, you could build on it instead of nested IFs =INDEX(E20:E23,MATCH(C16,{5,8,10,12})) -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=511411 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Function too Large
This works but I modified it to allow a 0 for numbers below 5:
=INDEX(E19:E23,MATCH(C16,{0,5,7,10,15})) I am currious though could I also enable this with differant functions? -- Thank you, Trying Hard "daddylonglegs" wrote: This could replace what you have so far, you could build on it instead of nested IFs =INDEX(E20:E23,MATCH(C16,{5,8,10,12})) -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=511411 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Function too Large
Trying Hard Wrote: ..... I am currious though could I also enable this with differant functions? ..... Not sure what you mean, you can certainly use that type of setup in many different circumstances. In general if you're using more than about 3 nested IFs you'll probably be better off with some sort of LOOKUP/INDEX/MATCH formula - the exact formula you need will depend on the exact circumstances -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=511411 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA function for "Mean" using Array as argument | Excel Worksheet Functions | |||
creating function (vba) with range arguments | Excel Worksheet Functions | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
Help on Large Function | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |