Excel, problem with a formula

Question

=C16*(MMULT(M,MMULT(M,MMULT(M,MMULT(M,MMULT(M,MMULT(M,MMULT(M,MMULT(M,M)))))))))-(E16*(M,MMULT(M,MMULT(M,MMULT(M,MMULT(M,M))))))+(D17*(M))-(E18*I)

when I click CTRL+SHIFT+ENTER it says:

There's a problem with this formula.

Not trying to type a foruma?

When the first charcter is an equal(=) or minus (-) sign, Excel thinks it's a formula.

you type: =1=1, cell shows : 2

To get around this, type an apostrphe (') firts:

you type: '=1=1, cell shows: =1+1

What's wrong with the formula? How do I make it work?

Thank you

Answer 1

Why so complicated?

At first correct the named range I to K16:M16 (your I includes the heading).

C22:E24: {=1*M^8-2*M^4+4*M-5*I}

Andreas.

Answer 2

Hi,

In formula you given in first post I think that M given in red is wrong.

=C16*(MMULT(M,MMULT(M,MMULT(M,MMULT(M,MMULT(M,MMULT(M,MMULT(M,MMULT(M,M)))))))))-(E16*(M,MMULT(M,MMULT(M,MMULT(M,MMULT(M,M))))))+(D17*(M))-(E18*I)

As for the second post I think you will need to apply the following formula. Initially select cells C22:E24 and then apply the formula. This formula will need to be applied with Ctrl+Shift+Enter.

=((C16:E18)*(G16:I18))^8-2*((C16:E18)*(G16:I18))^4+4*((C16:E18)*(G16:I18))-5*(K16:M18)

The Matrix M will need to be filled with the appropriate values (as shown on the printscreen given above).

Hope this hepls. If yes, please don't forget to mark my reply as Answer.

IlirU

Answer 3

Hi,

Seen the complexity to rebuild, can you share the workbook? Remove all confidential data before sharing .

Answer 4

Hello

M and I are matrices

Answer 5

Hi,

What is M & I in the formula?