To long formula for excel

[Edgar Voldgrud]

Like to find an answer too a long calculation in one cell, but the formule
become to long just before I'm finish.
A loop would have done it but I have no skills for to make it. what can I do
to get around it? have tryied in many ways but excel do not let me get an
answer to this.

What can I do?

Formula goes like this:

=MMULT(MINVERSE(MMULT(TRANSPOSE
OFFSET($L$80;DAG;0;Nobs;aksjer):OFFSET($L$80;DAG;0;Nobs;aksjer)-TRANSPOSE(MMULT(TRANSPOSE
OFFSET($L$80;DAG;K$78;Nobs;aksjer):OFFSET($L$80;DAG;K$78;Nobs;aksjer));R80:R109)/Nobs))
OFFSET($L$80;DAG;0;Nobs;aksjer):OFFSET($L$80;DAG;0;Nobs;aksjer)-TRANSPOSE(MMULT(TRANSPOSE
OFFSET($L$80;DAG;K$78;Nobs;aksjer):OFFSET($L$80;DAG;K$78;Nobs;aksjer));R80:R109)/Nobs))/(Nobs-1));
MMULT(TRANSPOSE
OFFSET($L$80;DAG;K$78;Nobs;aksjer):OFFSET($L$80;DAG;K$78;Nobs;aksjer));R80:R109)/Nobs-U101)/

SUM(MMULT(MINVERSE(MMULT(TRANSPOSE
OFFSET($L$80;DAG;0;Nobs;aksjer):OFFSET($L$80;DAG;0;Nobs;aksjer)-TRANSPOSE(MMULT(TRANSPOSE
OFFSET($L$80;DAG;K$78;Nobs;aksjer):OFFSET($L$80;DAG;K$78;Nobs;aksjer));R80:R109)/Nobs))
OFFSET($L$80;DAG;0;Nobs;aksjer):OFFSET($L$80;DAG;0;Nobs;aksjer)-TRANSPOSE(MMULT(TRANSPOSE
OFFSET($L$80;DAG;K$78;Nobs;aksjer):OFFSET($L$80;DAG;K$78;Nobs;aksjer));R80:R109)/Nobs))/(Nobs-1));
MMULT(TRANSPOSE
OFFSET($L$80;DAG;K$78;Nobs;aksjer):OFFSET($L$80;DAG;K$78;Nobs;aksjer));R80:R109)/Nobs-U101))

 

[ilia]

You're using this line over and over:

OFFSET($L$80;DAG;0;Nobs;aksjer)

Instead, define a name that refers to this statement and make it
short. You should be able to reduce the length of your formula in
this way.

 

[Edgar Voldgrud]

Don't seems like my reply earlier is here? Sorry Ilia it will not solve this
problem, but I have tried excel 2007 where max formula length is 8192
characters with success. Ended up with a new problem at 8192 c. today as I
guess I will get around.
Thanks a lot anyway