Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Bill Howell   on Sep 20 In MS Office Category.

  
Question Answered By: Billy Evans   on Sep 20

Not much information here to go on, but a couple of things stick out.

One, the function  declaration should probably be:

public function tax(status as string, income as currency) as currency

This would insure the return  value is of the type  currency.

Lastly, there should be a line executed before leaving the function that sets
the return value,

tax = (value)

Be aware that 'status' is a property used several places in VB, so you might
want to name it 'TaxStatus' instead.

Share: 

 

This Question has 3 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Different Parameters in Excel UDF Or get search suggestion and latest updates.


Tagged: