Formula returning false??

[dirtydan86]

I seem to be having a mental block and struggling to see where the formula is going wrong (as simpel as it is).

Formula is

=IF(K9="January",IF(J9<23,1,IF(J9<43,2,IF(J9<64,3,IF(J9<86,4,IF(J9<109,5,IF(J9<129,6,IF(J9<152,7,IF(J9<174,8,IF(J9<195,9,IF(J9<218,10,IF(J9<239,11,IF(J9>239,12,IF(K9="February",IF(J9<20,2,IF(J9<41,3,IF(J9<63,4,IF(J9<86,5,IF(J9<106,6,IF(J9<129,7,IF(J9<151,8,IF(J9<172,9,IF(J9<195,10,IF(J9<216,11,IF(J9>216,12,"")))))))))))))))))))))))))

J9 = 50
K9 = February

If i change K9 to Janaury it returns the correct number "3" but if i change it to February i get false? Any ideals where i am going wrong on this one? I dont fancy adding in the further months if i cant fix the 2nd

[dwint]

post your sample
when you have multiple if function in your formula, you should try to used SumProduct or LookUp function

[dirtydan86]

sample.xlsx sample data if you change K9 to January it works but not as february

[ConneXionLost]

Try this:

Please Login or Register  to view this content.

This would have been much shorter if you had provided lookup tables for the reference values.