Hello everyone this is my first post in these forums hopefully you guys could offer me some advice I have never done programming before and we had to take it in my computers business functions course.
I have to create a simple function where the program takes a grade either 100 - 50 or 49 -0 the program will then output "pass" for the first option and "fail" for the second.
When I use the function it says #VALUE! I cant figure out what is wrong. I am using excel 2010.
Thank you for any help you can offerFunction passfail(grade As Double) As Double
If grade >= 50 Then
passfail = ("Pass")
Else
If grade < 50 Then
passfail = ("Fail")
End If
End If
End Function
Bookmarks