Good Morning All,

I am using the below formula to assign a letter based on value of assigned within the formula:

=IF(E5="","",IF(E5<A$3,"C",IF(E5<C$3,"B",IF(E5<E$3,"A",IF(E5>E$3,"A")))))

I want the formula not to populate a letter if the value in E5 is 0, so far I have had no joy developing this.

Any help would be appriecated.

Regards,

Matt