user defined function
 

still struggling

Function Discount(quantity, price)

If quantity = 300 Then
Discount = quantity * price * 0.1
Else
Discount = 0
End If

End Function
-- I still cant find this function in the functions drop down box, is there
something else I have to do. thnaks
delmac

user defined function
 

Well, the obvious question is "where do you have the code?"


"delmac" wrote:

still struggling

Function Discount(quantity, price)

If quantity = 300 Then
Discount = quantity * price * 0.1
Else
Discount = 0
End If

End Function
-- I still cant find this function in the functions drop down box, is there
something else I have to do. thnaks
delmac