I need to use more than 9 nested if statements, is there a way to do this?
R RagDyer May 18, 2004 #2 Yes, there is a work-around, but you really don't want to use it. Post your particulars, and you should recieve some viable options to nesting so many arguments. -- Regards, RD
Yes, there is a work-around, but you really don't want to use it. Post your particulars, and you should recieve some viable options to nesting so many arguments. -- Regards, RD
H Harald Staff May 18, 2004 #3 See http://www.cpearson.com/excel/nested.htm on this. HTH. Best wishes Harald
F Frank Kabel May 18, 2004 #4 Hi normlly a lookup table and the use of VLOOKUP would be the solution. (see: http://www.mvps.org/dmcritchie/excel/vlookup.htm) you may provide some more detail (e.g. you existing formula)
Hi normlly a lookup table and the use of VLOOKUP would be the solution. (see: http://www.mvps.org/dmcritchie/excel/vlookup.htm) you may provide some more detail (e.g. you existing formula)
