fGrade function

[manshatayal6432]

Hi There I'm not able in finding fGrade function in my excel can somebody help.

[#2]

Hi @manshatayal6432 

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"))

[#3]

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.