• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Length of formula contents

K

kbk

New Member
I'm a newbie to excel. I have a lot of formulae from MATLAB which I'm trying to include in excel 2013. The length of these formulae exceeds excel limit of 8192 characters. Splitting the formula is a tad tedious. Is there an alternative solution to get around this limit?
 
Hi ,

I am sorry , but I am not able to find any way out of this , since Excel's limitation does not seem to have any workarounds.

Having said that I am interested to know how this formula has been formulated either by a user or by the Matlab program , since there are a lot of multiplications by 1 , and additions of 0 , both of which don't make any difference to the equation / formula ; can these be eliminated ?

Narayan
 
NARAYANK991 said:
Hi ,

I am sorry , but I am not able to find any way out of this , since Excel's limitation does not seem to have any workarounds.

Having said that I am interested to know how this formula has been formulated either by a user or by the Matlab program , since there are a lot of multiplications by 1 , and additions of 0 , both of which don't make any difference to the equation / formula ; can these be eliminated ?

Narayan
Click to expand...
Thanks for trying. Yes, it is coming from a different program similar to MATLAB. This is a unique case where we have additions of zero and multiplication by 1. Usually, there will be a non-zero decimal.
 
Hi kbk,
I observed that there are 4 calculations which are repeating no. of times (below it is mentioned). So if you do these calculations in 4 different cells and pass the cell ref. of those cells to the main formula, that might reduce the length of formula.

((1*((V-2)/6.58)+0)/1)
((1*((D-0.0001)/0.2)+0)/1)
((1*((F-5)/995)+0)/1)
((1*((T-2.03)/17.89)+0)/1)

Regards,
 
Somendra Misra said:
Hi kbk,
I observed that there are 4 calculations which are repeating no. of times (below it is mentioned). So if you do these calculations in 4 different cells and pass the cell ref. of those cells to the main formula, that might reduce the length of formula.

((1*((V-2)/6.58)+0)/1)
((1*((D-0.0001)/0.2)+0)/1)
((1*((F-5)/995)+0)/1)
((1*((T-2.03)/17.89)+0)/1)

Regards,
Click to expand...
Thanks for the astute observation. Unfortunately, this particular example is unique where such repetitions occur and also things like adding 0's and multiplications by 1 and so on. I have a whole bunch of formulae where such don't exist and I'm lost in trying to split them :-(
 
You must log in or register to reply here.
Back
Top