View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.misc
vezerid vezerid is offline
external usenet poster
 
Posts: 751
Default Multiple Matrix calculations from data list

Gary,

by now I think it is pretty clear that you need my second formula:

=MDETERM(A2:B3-A1:B2)

Remember to commit with Shift+Ctrl+Enter. You can then copy down.

HTH
Kostis

Gary B wrote:
Again...another mistake

The first determinant would be =MDETERM({1,1;1,5}) = 4