How to insert a formula in between sentences with a value result?

Question

How do I insert formula in between sentences with a dollar value formatting as the returned result? For example, in A3 I want to write:

="Total Invoice: $"&B1+B2

So the result should appear as "Total Invoice: $6,548.32"

However, when the formula is entered in excel, results come out as "Total Invoice: $6548.32375"

How can I control the result to only display 2 decimal points as well as the comma when required?

teylyn · Accepted Answer · 2013-01-30 07:07:25Z

4

I don't think chuff's suggestion will work, since the B2 value is appended to the number, not added. This is probably what you need:

="Total Invoice: "&text(B1+B2,"$#,##0.00")

answered Jan 30, 2013 at 7:07

teylyn

22.8k2 gold badges41 silver badges54 bronze badges

Add a comment |

barry houdini · Accepted Answer · 2013-01-30 09:54:52Z

2

DOLLAR function will display your default currency, e.g.

="Total Invoice: "&DOLLAR(B1+B2)

answered Jan 30, 2013 at 9:54

barry houdini

11k1 gold badge21 silver badges25 bronze badges

Add a comment |

chuff · Accepted Answer · 2013-01-30 06:51:47Z

0

This formula will give the proper formatting:

    ="Total Invoice: "&TEXT(B1,"$#,##0.00")&B2

Note that the dollar sign is taken care of in the format specified in the TEXT function, so no need to include it in the initial string.

You can find more information about the TEXT function here.

answered Jan 30, 2013 at 6:44

chuff

3,5041 gold badge16 silver badges19 bronze badges

Add a comment |

3 Answers 3