Apr 21 2018 06:58 PM - last edited on Jul 25 2018 11:47 AM by TechCommunityAPIAdmin
=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
Apr 23 2018 11:03 AM
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
