View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
LurfysMa LurfysMa is offline
external usenet poster
 
Posts: 61
Default Help defining a user-defined function

In Excel 2000, I need to create a user-defined function to execute an
exponential formula with 4 parameters: Xa, Ya, Yb, & h.

The formula is:

y = Yb + (Ya-Yb) * exp( (ln(2)/h) * (X-Xa) )

I would like the function created so that I can use it justr like the
built-in functions such as power: =power(B5,E9).

I would like to invoke my function like this:

=MyExp(B5,C5,D5,F5)

Thanks for any help or pointers.

--