What is the max number of If statements you can use in a formula ? Thanks, yosef
Y ynissel Aug 22, 2005 #1 What is the max number of If statements you can use in a formula ? Thanks, yosef
A Anne Troy Aug 22, 2005 #2 7 embedded IFs, which means you can have the word IF a total of 8 times. ************ Anne Troy www.OfficeArticles.com
7 embedded IFs, which means you can have the word IF a total of 8 times. ************ Anne Troy www.OfficeArticles.com
J JE McGimpsey Aug 22, 2005 #4 You can have dozens of IF() statements, but they can only be nested 7 deep. For a workaround, see http://cpearson.com/excel/nested.htm OTOH, if you have to nest more than 4 or 5 deep, it's almost always easier to use an alternative method, e.g., Lookups, math operations, etc.
You can have dozens of IF() statements, but they can only be nested 7 deep. For a workaround, see http://cpearson.com/excel/nested.htm OTOH, if you have to nest more than 4 or 5 deep, it's almost always easier to use an alternative method, e.g., Lookups, math operations, etc.
