This is about scientific representation of values in “CONCATENATE”. Excel formula.
Variable which are more than 4 digits in length can be represented in engineering format with following formula.
TEXT(C6,"###.00E+00")
TEXT(C6,"###.00E+00")
Some of the variables in below worksheet are more than 4 digits in length.
A | B | C | D | E | F | G | H | |
1 | Number | Formated to scientific | ||||||
2 | tI | = | 60.00 | 60.00 | ||||
3 | JS | = | 0.09 | 0.09 | ||||
4 | MbI | = | 8584906.32 | 8.58E+06 | ||||
5 | JP | = | 0.07 | 0.065 | ||||
6 | MP | = | 171412565.14 | 171.41E+06 | ||||
7 | EI*qrbI | = | -163172576.98 | -163.17E+06 | ||||
Equation in which these variables shall be used is,
9 | EIqBI | = | (5.46/(3.142*t13))(JSMbI+JPMP)+(EI*qrbI)/tI3 | --- | --- | (25) |
=CONCATENATE("(5.46/(3.142*",C2,"^",3,"))(",C3,"*",C4,"+",C5,"*",C6,")","+","(",C7,")/",C2,"^3")
With this formula representation will be,
10 | EIqBI | = | (5.46/(3.142*60^3))(0.09*8584906.32+0.065*171412565.14)+(-163172576.98)/60^3 |
=CONCATENATE("(5.46/(3.142*",C2,"^",3,"))(",C3,"*",TEXT(C4,"###.00E+00"),"+",C5,"*",TEXT(C6,"###.00E+00"),")","+","(",TEXT(C7,"###.00E+00"),")/",C2,"^3")
& the Equation will be.
11 | EIqBI | = | (5.46/(3.142*60^3))(0.09*8.58E+06+0.065*171.41E+06)+(-163.17E+06)/60^3 |
