Thread: functions
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
marwan hefnawy marwan hefnawy is offline
external usenet poster
 
Posts: 16
Default functions

dear all
I have two questions

1) How can I write a function that accepts multiple inputs (arguments) and
return multiple values? The straightforward method accepts multiple values
and returns a single value (that is the name of the function)

2) How can I write a function that accepts multiple arrays as input
arguments and returns an array too.

ex: if I have two arrays x , y
how can I configure a function f(x,y) that return an array representing the
pointwise multiplication of x,y
i.e f(i)= x(i)* y(i)

thanks in advance