Hi everyone,
Is it possible to set a range using comparison operators? ie. if a number lies within x and y then such and such happens.
To be more precise:
Function grade(maths As Double, english As Double, science As Double) As String
If maths >= 70 And english >= 70 And science >= 70 Then
grade = "Distinction"
ElseIf maths >= 70 And english >= 50 And science >= 50 Then
grade = "Merit"
ElseIf maths < 50 Or english < 50 Or science < 50 Then
grade = "Fail"
End If
End Function
Focusing on the red text, I was hoping to set english and science so that they are also < 70 (lie between 50 - 69).
Thanks for your time!
Bookmarks