Concatenate with dollar values from cells

gheyman

Well-known Member
Joined
Nov 14, 2005
Messages
1,814
Office Version
  1. 365
Platform
  1. Windows
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%"
 

Some videos you may like

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

Taul

Well-known Member
Joined
Oct 24, 2004
Messages
748
Office Version
  1. 2019
  2. 2013
Platform
  1. Windows
Hi,
In cell J40

Book1
IJK
33
34$126.00
35
36$37.00
37
383.405405
39
40$126 / $37 = 3.405%
41
Sheet1
Cell Formulas
RangeFormula
J38J38=J34/J36
J40J40="$"&J34&" / $"&J36&" = "&ROUND(J38,3)&"%"
 
Solution

gheyman

Well-known Member
Joined
Nov 14, 2005
Messages
1,814
Office Version
  1. 365
Platform
  1. Windows
Thank you! that worked perfectly
 

Taul

Well-known Member
Joined
Oct 24, 2004
Messages
748
Office Version
  1. 2019
  2. 2013
Platform
  1. Windows
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

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
47,926
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

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
383.405405405
39
40$126.00/$37.00 =340.541%
Text formula
Cell Formulas
RangeFormula
J38J38=J34/J36
J40J40=TEXT(J34,"$0.00\/")&TEXT(J36,"$0.00 =")&TEXT(J38,"0.000%")
 

gheyman

Well-known Member
Joined
Nov 14, 2005
Messages
1,814
Office Version
  1. 365
Platform
  1. Windows
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

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
47,926
Office Version
  1. 365
Platform
  1. Windows
Cheers. Thanks for the clarification.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,387
Messages
5,601,344
Members
414,447
Latest member
CRAVIN

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top