Concatenate, currency & sum formula
 

I am using the concatenate function to add an asterisk at the end of a currency formula in a cell but it is not recognizing the currency. My formula is below:

=concatenate("$",sum(d25,c26),"*")

My answer in the cell is $102387327.45

This does not have a "," and it would not have a $ if I would have not added it. Thanks!!!!

Concatenate, currency & sum formula
 

"mcoker1" wrote:
I am using the concatenate function to add an asterisk at the end of a
currency formula in a cell but it is not recognizing the currency. My
formula is below:
=concatenate("$",sum(d25,c26),"*")
[....]
This does not have a "," and it would not have a $ if I would have not
added it. Thanks!!!!

One way:

=D25+C26

formatted as Custom $#,##0.00\* . That preserves the numeric type of the
cell, so you can still reference in other formulas.

Alternatively, if you want a text result:

=TEXT(D25+C26,"$#,##0.00\*")

perhaps formatted with Right Horizontal Alignment.

Use SUM(D25,C26) instead of D25+C26 only if D25 or C26 might contain
(non-numeric) text, and you want to avoid a #VALUE error in that case.

GREAT!!! Thank you so much! I used the second option and it worked. I had tried difference formulas for over an hour. Such a relief!