Excel 97 formula doesn't work in Excel 2007

[Divius]

I got in excel a matrix with 25 percentages (B26:F30)
100,0,0,0,0
0,100,0,0,0
0,0,100,0,0
0,0,0,100,0
0,0,0,0,100
and in a row 5 times a value of 100% (F6:F10).
I need as output the value 125.

Originally this value was found with the following excel formula

=MMULT(MMULT(TRANSPOSE(F6:F10),MINVERSE(B26:F30)),F6:F10)

But when I try this in excel 2007 I get no value error. I think some adjustments have to be made to the formula.

Thanks in advance!

[davesexcel]

Do you have it entered as an array formula?
Here it is explained
http://office.microsoft.com/en-us/ex...091811033.aspx

[Divius]

Yes I did, but as excel indicates that there is something wrong in the formula the formula doesn't provide a value.

[Divius]

I tried to change the , for ; but this doesn't have a positive effect on the formula.

[Divius]

Solved it made a mistake in de matrix.