Excel - Engineering formatted values in "“CONCATENATE”.

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")

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