What is the maximum number of IF statements allowed per cell
B bj Jun 23, 2005 #2 If they are nested, (if(xx,If(yy,if....))) 7 but there are ways to have multiples without them being nested dependong on your needs.
If they are nested, (if(xx,If(yy,if....))) 7 but there are ways to have multiples without them being nested dependong on your needs.
S swatsp0p Jun 23, 2005 #3 you can 'nest' a total of 7 IF statements in a formula. often, othe options are better suited when that many IF statements are required such as a vlookup table
you can 'nest' a total of 7 IF statements in a formula. often, othe options are better suited when that many IF statements are required such as a vlookup table
