Mar 13 2022 12:46 AM
Hi There I'm not able in finding fGrade function in my excel can somebody help.
Mar 13 2022 01:44 AM
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"))
Mar 13 2022 01:54 AM