Is it possible to concatenate currency input with number that is the result of a formula without relying on a intermediary cell? Example: cells have the format e.g. “$55 (26)” which means $55 due in 26 days. I just want to enter “55” and it should have the prefix
$ and ideally be treated as a currency so I can sum up the dollar amounts of the cells. 26 days is the result of a formula returning a number.
What I’m looking for is
$<user-input to be treated as currency> (<number output of formula>). I can have one column for the dollar amount and another column for number of dates, but grouping them in this context is more intuitive for me. Also just curious if this can be done.