Forum Discussion
Solved
If(and) I believe
Hello! Cell BA4 has a sum in it, anywhere from 0-10. In cell BB4, I would like to turn that number into a "Grade" ie. . A,B,C,D with the following criteria. Is this possible? Thank you in advance...
I have modified the formula now it will show blank in case of zero sum.
=IFS(H12=0,"",H12>6.9,"A+",H12>4.9,"A",H12>3.9,"B",H12>2.9,"C",H12<=2.9,"D")
Thanks
Tauqeer
hi JMB1001
Suppose sum is in cell H14 you may use below formula:
=IFS(H12>6.9,"A+",H12>4.9,"A",H12>3.9,"B",H12>2.9,"C",H12<2.9,"D")
Hope it will help
Thanks
Tauqeer
alternatively
=IF(A1<=" ","",CHOOSE(MEDIAN(1,INT(A1)-1,6),"D","C","B","A","A","A+"))
I editted based on new request for blank
here is tauqeeracma version with blank added:
=IFS(H12<=" ","",H12>6.9,"A+",H12>4.9,"A",H12>3.9,"B",H12>2.9,"C",H12<2.9,"D")
- yea I wrote before that added request was added. and then I edit it before I saw your update. lol
btw though, if the grade is 0 may be different than being blank