how to create user defined function or custom function in excel.

Video URL https://youtu.be/v6N7H9Zu2J8


1.Create Blank Excel Sheet
2.Hit Alt + F11 to switch to code view
3.Select your current Workbook.
4.Go to Insert > Module and Copy paste the code below

Public Function sResult(Mrks As Integer)

If Mrks > 50 Then
    sResult = "Pass"
Else
    sResult = "Fail"
End If

End Function




















4.Hit Alt + Fll to come back to excel window and write "=sResult(B2)" in the Cell to get result for marks entered in B2 Cell