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.
2 Replies
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"))
- manshatayal6432Copper ContributorHii thankyou for response actually i want to add some of the grace marks in the existing no. Of students through fGrade in VBA excel.