Forum Discussion
manshatayal6432
Mar 13, 2022Copper Contributor
fGrade function
Hi There I'm not able in finding fGrade function in my excel can somebody help.
Mar 13, 2022
There is no function called fgrade as per my knowledge
Do you want to assign letter for grade or something similar, such as:
less thank 60 --> F
60-69 -->D
70-79 -->C
80-89 --> B
more than 90 --> A
=IFS(A1>=90,"A",A1>=80,"B",A1>=70,"C",A1>60,"D",A1>0,"F"))
manshatayal6432
Mar 13, 2022Copper Contributor
Hii thankyou for response actually i want to add some of the grace marks in the existing no. Of students through fGrade in VBA excel.