Concatenate with dollar values from cells

[gheyman]

I have two cells that have dollar values in them (J34 and J36). I have another cell (J38) that divides the two ($126 / $37 = 3.405405). I need to put in a cell a formula that shows the "Formula". Therefore I need to concatenate the values in the three fields. So I need a concatenate formula that would show "$126 / $37 = 3.405%"

 

[Taul]

Hi,
In cell J40

Book1
	I	J	K
33
34		$126.00
35
36		$37.00
37
38		3.405405
39
40		$126 / $37 = 3.405%
41
Sheet1

Cell Formulas
Range	Formula
J38	J38	=J34/J36
J40	J40	="$"&J34&" / $"&J36&" = "&ROUND(J38,3)&"%"

 

[gheyman]

Thank you! that worked perfectly

 

[Taul]

You're welcome,
I have just tried to answer your question to concatenate the values.
I'm not sure what the whole system is but I can't help noticing that $37 is not 3.405% of $126
It is $29.36%

cheers
Paul.

 

[Peter_SSs]

but I can't help noticing that $37 is not 3.405% of $126

I agree that the % looks wrong but in any case another style of answering the question that goes more to matching the input values formatting (eg decimal places) could be something like this.

20 11 19.xlsm
	J
34	$126.00
35
36	$37.00
37
38	3.405405405
39
40	$126.00/$37.00 =340.541%
Text formula

Cell Formulas
Range	Formula
J38	J38	=J34/J36
J40	J40	=TEXT(J34,"$0.00\/")&TEXT(J36,"$0.00 =")&TEXT(J38,"0.000%")

 

[gheyman]

my bad, the numbers I used was just for an example - I should have checked the math. Bottom line the formula provided worked.

 

[Peter_SSs]

Cheers. Thanks for the clarification.