Excel does have a set of matrix functions like MMULT that takes as
parameters two arrays and outputs the results as another array, which
is what I am attempting to create with my function.

I also explored using a subroutine but it required the user  to invoke
a procedure call or the subroutine needed to be event driven. It also
seemed to require some designated area of the worksheet to hold the
parameters read by the subroutine or the parameters tables needed to
be in a predefined position. This was too restrictive for the
functions planned use.

I've done a little more research and my current thinking is to not
use a range  as the function  return data type but to use an array.