To long formula for excel
 

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;DA G;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;DA G;K$78;Nobs;aksjer));R80:R109)/Nobs))/(Nobs-1));
MMULT(TRANSPOSE(
OFFSET($L$80;DAG;K$78;Nobs;aksjer):OFFSET($L$80;DA G;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;DA G;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;DA G;K$78;Nobs;aksjer));R80:R109)/Nobs))/(Nobs-1));
MMULT(TRANSPOSE(
OFFSET($L$80;DAG;K$78;Nobs;aksjer):OFFSET($L$80;DA G;K$78;Nobs;aksjer));R80:R109)/Nobs-U101))

To long formula for excel
 

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.




On Dec 10, 11:24 am, Edgar Voldgrud
wrote:
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(M-MULT(TRANSPOSE(
OFFSET($L$80;DAG;K$78;Nobs;aksjer):OFFSET($L$80;DA G;K$78;Nobs;aksjer));R80:-R109)/Nobs));
OFFSET($L$80;DAG;0;Nobs;aksjer):OFFSET($L$80;DAG;0 ;Nobs;aksjer)-TRANSPOSE(M-MULT(TRANSPOSE(
OFFSET($L$80;DAG;K$78;Nobs;aksjer):OFFSET($L$80;DA G;K$78;Nobs;aksjer));R80:-R109)/Nobs))/(Nobs-1));
MMULT(TRANSPOSE(
OFFSET($L$80;DAG;K$78;Nobs;aksjer):OFFSET($L$80;DA G;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(M-MULT(TRANSPOSE(
OFFSET($L$80;DAG;K$78;Nobs;aksjer):OFFSET($L$80;DA G;K$78;Nobs;aksjer));R80:-R109)/Nobs));
OFFSET($L$80;DAG;0;Nobs;aksjer):OFFSET($L$80;DAG;0 ;Nobs;aksjer)-TRANSPOSE(M-MULT(TRANSPOSE(
OFFSET($L$80;DAG;K$78;Nobs;aksjer):OFFSET($L$80;DA G;K$78;Nobs;aksjer));R80:-R109)/Nobs))/(Nobs-1));
MMULT(TRANSPOSE(
OFFSET($L$80;DAG;K$78;Nobs;aksjer):OFFSET($L$80;DA G;K$78;Nobs;aksjer));R80:-R109)/Nobs-U101))

To long formula for excel
 

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

"ilia" wrote:

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.




On Dec 10, 11:24 am, Edgar Voldgrud
wrote:
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(M-MULT(TRANSPOSE(
OFFSET($L$80;DAG;K$78;Nobs;aksjer):OFFSET($L$80;DA G;K$78;Nobs;aksjer));R80:-R109)/Nobs));
OFFSET($L$80;DAG;0;Nobs;aksjer):OFFSET($L$80;DAG;0 ;Nobs;aksjer)-TRANSPOSE(M-MULT(TRANSPOSE(
OFFSET($L$80;DAG;K$78;Nobs;aksjer):OFFSET($L$80;DA G;K$78;Nobs;aksjer));R80:-R109)/Nobs))/(Nobs-1));
MMULT(TRANSPOSE(
OFFSET($L$80;DAG;K$78;Nobs;aksjer):OFFSET($L$80;DA G;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(M-MULT(TRANSPOSE(
OFFSET($L$80;DAG;K$78;Nobs;aksjer):OFFSET($L$80;DA G;K$78;Nobs;aksjer));R80:-R109)/Nobs));
OFFSET($L$80;DAG;0;Nobs;aksjer):OFFSET($L$80;DAG;0 ;Nobs;aksjer)-TRANSPOSE(M-MULT(TRANSPOSE(
OFFSET($L$80;DAG;K$78;Nobs;aksjer):OFFSET($L$80;DA G;K$78;Nobs;aksjer));R80:-R109)/Nobs))/(Nobs-1));
MMULT(TRANSPOSE(
OFFSET($L$80;DAG;K$78;Nobs;aksjer):OFFSET($L$80;DA G;K$78;Nobs;aksjer));R80:-R109)/Nobs-U101))