Forum Discussion

Copper Contributor

Apr 21, 2018

I need a formula for this

=if(M7>=90,A,if(M7>=80,B,if(M7>=70,C,if(M7>=60,D,if(M7<=59,F))))) I need a formula for this

Silver Contributor

Apr 23, 2018

Hi,

You have to wrap each letter A, B, etc with double quote "<letter>" as follows:

=IF(M7="","",IF(M7>=90,"A",IF(M7>=80,"B",IF(M7>=70,"C",IF(M7>=60,"D",IF(M7<=59,"F"))))))

Regards