Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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)) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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)) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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)) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EXCEL ERROR - series formula is too long | Excel Worksheet Functions | |||
Clearing cells takes long, long time | Excel Discussion (Misc queries) | |||
why does excel 2000 take a long time to calculate formula? | Excel Discussion (Misc queries) | |||
error: Formula is to long in Excel - How can I fix this? | Excel Discussion (Misc queries) | |||
Formula Too Long | Excel Discussion (Misc queries) |