View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Leo Heuser Leo Heuser is offline
external usenet poster
 
Posts: 266
Default Can I raise a matrix to a power?

"dled" skrev i en meddelelse
...
I have a couple of 40x 40 matrices, that I would like to raise to various
powers. Can this be done, short of using the mmult function and
multipling
each matrix by itself over and over?



If your matrix cover cells e.g. A1:AN40,
select a 40x40 range and enter the formula
=A1:AN40^3 (while the range is selected)

Confirm with <Shift<Ctrl<Enter

You now have your matrix raised to the third power.

--
Best regards
Leo Heuser

Followup to newsgroup only please.