Did you array enter the formula? Ctrl+Shift+Enter Rather than just Enter?

--
Regards,
Tom Ogilvy

"Sam" wrote in message
om...
hi there

my formula is

=SQRT(MMULT(MMULT(AV47:BM47,$I$47:$Z$64),TRANSPOSE (AV47:BM47)))

all cells have numbers in them as values.....
i m getting #value ....
can some one pls help ?

sam