Need help with excel formula?

-im having trouble finding the problem.

=IF(General!C5=1,N10=2,

IF(General!C5=2,N10=3,

IF(General!C5=3,N10=3,

IF(General!C5=4,N10=4,

IF(General!C5=5,N10=4,

IF(General!C5=6,N10=5,

IF(General!C5=7,N10=5,

IF(General!C5=8,N10=6,

IF(General!C5=9,N10=6,

IF(General!C5=10,N10=7,

IF(General!C5=11,N10=7,

IF(General!C5=12,N10=8,

IF(General!C5=13,N10=8,

IF(General!C5=14,N10=9,

IF(General!C5=15,N10=9,

IF(General!C5=16,N10=10,

IF(General!C5=17,N10=10,

IF(General!C5=18,N10=11,

IF(General!C5=19,N10=11,

IF(General!C5=20,N10=12,

"no input"))))))))))))))))))))



instead of using the true statement to fill in N10, it fills in 0.This should work for you:



=IF(General!C5>0,LOOKUP(General!C5,

{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,1鈥?br>
17,18,19,20;1,2,3,3,4,4,5,5,6,6,7,7,8,鈥?br>
9,9,10,10,11,12}),"No Input")





Your if statement is limited to 7 levels.
=IF(OR(General!C5<1,General!C5>20),"No input",CHOOSE(General!C5, 2,3,3,4,4,5,5,6,6,7,7, 8,8,9,9,10,10,11,11,12))