Forum Discussion

2 Replies

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

    • manshatayal6432's avatar
      manshatayal6432
      Copper 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.

Resources