Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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!!!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
|
|||
|
|||
Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenate with currency w/2 decimal places | Excel Programming | |||
Currency formula | Excel Worksheet Functions | |||
lookup formula for currency | New Users to Excel | |||
Currency Formula | Excel Discussion (Misc queries) | |||
How do I concatenate two currency cells to show a price range? | Excel Worksheet Functions |