How Can I Post These Mutliple If Statements In One Cell?

[aedctalk]

How Can I Post These Mutliple If Statements In One Cell? PLEASE

Thank you so much in advance!!

=if(Configuration!J40=8, 9, if(Configuration!J40=9, 10),if(Configuration!J40=10, 11),if(Configuration!J40=11, 12),if(Configuration!J40=12, 13),if(Configuration!J40=13, 14),if(Configuration!J40=14, 15),if(Configuration!J40=15, 16),if(Configuration!J40=16, 17),if(Configuration!J40=17, 18),"")

 

[MrKowz]

You can only have up to seven nested statements. Try:

=IF(AND(Configuration!J40>=8,Configuration!J40<=17),Configuration!J40+1,"")

 

[sous2817]

I'm sure there's a better way, but does:

=IF(Configuration!J40=8,9,IF(Configuration!J40=9,10,IF(Configuration!J40=10,11,IF(Configuration!J40=11,12,IF(Configuration!J40=12,13,IF(Configuration!J40=13,14,IF(Configuration!J40=14,15,IF(Configuration!J40=15,16,IF(Configuration!J40=16,17,IF(Configuration!J40=17,18,""))))))))))

work?

 

[violet_universe]

How Can I Post These Mutliple If Statements In One Cell? PLEASE

Thank you so much in advance!!

=if(Configuration!J40=8, 9, if(Configuration!J40=9, 10),if(Configuration!J40=10, 11),if(Configuration!J40=11, 12),if(Configuration!J40=12, 13),if(Configuration!J40=13, 14),if(Configuration!J40=14, 15),if(Configuration!J40=15, 16),if(Configuration!J40=16, 17),if(Configuration!J40=17, 18),"")

=IF(Configuration!J40>17,"",Configuration!J40+1)

 

[jvanbonn]

=IF(AND(Configuration!J40>7,Configuration!J40<18),Configuration!J40+1,"")