Is there an easy way to do a dot-product or cross-product function (matrix algebra) in Excel?

[travich]

I would have expected a one-step cross- or dot-product function in
Excel, since most other simple matrix algebra functions are
represented, but I can't seem to find one. Because laziness is the
step-mother of invention, I thought I'd ask around if anyone knows
where I can find this function before I attempted to write one.

This is highly annoying, since I know of at least four or five standard
engineering uses for cross and dot products and I will be performing
most of them on a regular basis over the next few years.

 

[Michael R Middleton]

travich -

Go to www.google.com.
Click on Groups.
Click on "Advanced Groups Search."
In "with all of the words" type "dot product" without the quotes.
In "Return only messages from the group" type "microsoft.public.excel.*"
without the quotes.
Click on Google Search.

- Mike
www.mikemiddleton.com

I would have expected a one-step cross- or dot-product function in Excel,
since most other simple matrix algebra functions are represented, but I
can't seem to find one. Because laziness is the step-mother of invention, I
thought I'd ask around if anyone knows where I can find this function before
I attempted to write one.

This is highly annoying, since I know of at least four or five standard
engineering uses for cross and dot products and I will be performing most of
them on a regular basis over the next few years.