Concatenate, currency & sum formula

[mcoker1]

I am using the concatenate function to add an asterisk at the end of
currency formula in a cell but it is not recognizing the currency. M
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 no
added it. Thanks!!!

 

[joeu2004]

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.

 

[mcoker1]

I am using the concatenate function to add an asterisk at the end o 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 hav not
added it. Thanks!!!!-

One way:

=D25+C26

formatted as Custom $#,##0.00\* . That preserves the numeric type o
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.
had tried difference formulas for over an hour. Such a relief