if formula

[Godders199]

Hi, i have built this if formula, which works correctly until the last if CZ>99 criteria is met, when the formula returns #Name?
=IF(CW2<3,"Catch up",IF(AND(RIGHT(E2,3)<>"MPM",CL2>0),"100% Testing",IF(OR(CD2>100,CI2>100,CH2>100),"100% Testing",IF(CY2>99,"100% Testing CI",IF(CZ>99,"100% testing IPP",)))))

grateful if someone could help me with the last element of this formula

thanks

 

[Special-K99]

=IF(CW2<3,"Catch up",IF(AND(RIGHT(E2,3)<>"MPM",CL2>0),"100% Testing",IF(OR(CD2>100,CI2>100,CH2>100),"100% Testing",IF(CY2>99,"100% Testing CI",IF(CZ>99,"100% testing IPP",)))))

There's no such cell reference as CZ
It's being interpreted as a named range which doesn't exist hence the #NAME error

 

[Godders199]

thanks, been looking at for ages.. just did not spot the obvious