software

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 amp; 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 gt;11,E23,0))))))))

How can I build this function combining criteria as a range for a common
result?

--
Thank you,

Trying Hard


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: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=511411This 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 Hardquot;daddylonglegsquot; wrote:

gt;
gt; This could replace what you have so far, you could build on it instead
gt; of nested IFs
gt;
gt; =INDEX(E20:E23,MATCH(C16,{5,8,10,12}))
gt;
gt;
gt; --
gt; daddylonglegs
gt; ------------------------------------------------------------------------
gt; daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
gt; View this thread: www.excelforum.com/showthread...hreadid=511411
gt;
gt;


Trying Hard Wrote:
gt; .....
gt; I am currious though could I also enable this with differant
gt; functions?
gt; .....

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: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=511411