NESTED IF returning false

Hello

I'm not great with nested IF's and I've created one in the attached workbook which is giving FALSE as the result. I've looked on here to see if I can suss out what I'm doing wrong and I'm still non the wiser. Can anybody help me with this please?

Thanks very much :-)

Your formula is over complicated as if something isn't met by the first condition it will be the second . Should <=52 be < 52 as does 52 meet your criteria. I am not sure what your conditions are, if you write them in english then it would be easier to check formula

Please Login or Register  to view this content.

Weeks Employed and earning level
<52 and above LEL result is Following 33 weeks pay at SMP rate
<52 and below LEL result is "then 12 weeks at 50% of earnings
>=52 and above LEL result is then 12 weeks at 50% of annual earnings plus SMP
>=52 and below LEL result is nothing
is this what you really want?

Sorry I've not made it very clear have I? The criteria is very confusing!

It should be as follows:-
<52 and above LEL result is Following 33 weeks pay at SMP rate
<52 and below LEL result is nothing
>=52 and above LEL result is then 12 weeks at 50% of annual earnings plus SMP
>= 52 and below LEL result is Then 12 weeks at 50% of earnings

Thanks for your help with this, much appreciated

=IF(AND(D14="Above LEL",Sheet2!G8<=52),"Following 33 weeks pay at SMP rate",IF(D14="Above LEL","then 12 weeks at 50% of annual earnings plus SMP",IF(AND(D14="LEL",Sheet2!G8<=52),"","then 12 weeks at 50% of earnings")))

Works perfectly, thanks so much. I will keep a note of this and use the AND going forward, much easier :-)