TEXT function and Data Table issue

[bigleauge123]

Hi all,

I am running two data tables, each with the same x-axis and y-axis variables, but two different outputs. One output is a percentage in 0.00% format and the other is a multiple in the 0.00x format. Once I run each data table, I am trying to use the =Text function to combine them to present one table that includes both outputs. However, everything works fine until my 0.00x values on my multiple data table drop below 1.00x. For example, see the highlghted picture below.

Also, the function I'm using is =TEXT(reference cell,"0.00%"&" | "&TEXT(refence cell,"0.00x))

Any help would be very much appreciated as none of the excel experts in my office had any solutions and neither did google!!

 

[Jeffrey Mahoney]

I created your formula. I noticed your formula didn't have the end quotes for the last format type and an extra )

Book6
	D	E	F	G
7	-10.63%	0.66		-10.63% | 0.66x
Sheet1

Cell Formulas
Range	Formula
G7	G7	=TEXT(D7,"0.00%")&" | "&TEXT(E7,"0.00x")

 

[bigleauge123]

That missing end quotes was a typo but the missing ) solved it!! thank you so much!

This is the working formula

=TEXT(AI54,"0.00%")&" | "&TEXT(AI42,"0.00x")