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.
|