We are asked to write a VBA function which returns the corresponding grade point according to...

 

Transcribed Image Text:

We are asked to write a VBA function which returns the corresponding grade point according to the input argument grade. You can assume that grade always contains a valid letter grade. Finish the below function Grade Point (). (10 marks) Function GradePoint (grade as string) As Double deal with the letter only. That is, Grade Point = InStr (__, "FDCBA", Left ( 1 Grade Point = 1 deal with the sign now If Right ( GradePoint = ElseIf Right ( GradePoint End If End Function ignore the sign for now )) = "+" Then ) = "-" Then O We are asked to write a VBA function which returns the corresponding grade point according to the input argument grade. You can assume that grade always contains a valid letter grade. Finish the below function Grade Point (). (10 marks) Function GradePoint (grade as string) As Double deal with the letter only. That is, Grade Point = InStr (__, "FDCBA", Left ( 1 Grade Point = 1 deal with the sign now If Right ( GradePoint = ElseIf Right ( GradePoint End If End Function ignore the sign for now )) = "+" Then ) = "-" Then O

Answer rating: 100% (QA)

InStr InStr Start String1 String2 Compare returns the position ... View the full answer