View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
delmac delmac is offline
external usenet poster
 
Posts: 30
Default 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