=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

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

Forum Discussion

null null

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

Formulas & Functions

Need Help

1 Reply

Haytham Amairah
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