Forum Discussion
Solved
MMULT & MINVERSE Functions
Hi, I need to know why I cannot find out the calculations of the following formula: =MMULT(MINVERSE(Q59:R60, T59:T60)) I am using Excel through MacBook Air.
You are welcome! The formula in the screenshot is not the suggested formula! Please copy the formula below and paste it in your formulabar!
=SUMPRODUCT(MMULT(MINVERSE(Q59:R60),T59:T60))
=SUMPRODUCT(MMULT(MINVERSE(Q59:R60),T59:T60))
=MMULT(MINVERSE(Q59:R60),T59:T60)
Do these formulas return the intended result?
OliverScheurich I uploaded the wrong pic! My sincere apology!
OliverScheurich Thank you for your response! However I still find it impossible to fix the issue!
You are welcome! The formula in the screenshot is not the suggested formula! Please copy the formula below and paste it in your formulabar!
=SUMPRODUCT(MMULT(MINVERSE(Q59:R60),T59:T60))
