Using text and formatting sum function in formula

B

Billy B

I am attempting to show text in a cell concatenated with the sum function and
it works fine. The problem is the result has 10 decimal places in the
resulting number. I have tried to use the format function with the sum
function without success. Here is the formula I am working with:

="Total is: " & Format(SUM(B96:B104),"0.00")

What am I doing wrong?
Thank you.
 
S

Squeaky

Hi Billy,

Try using the ROUND function.

="Total is: "&ROUND(SUM(B2:B3),2)

Omit the spaces around the &.

Squeaky
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum Function has small remainder 2
Use TODAY() function as the criteria in a SUMIF formula 1
Using SUM(INDIRECT()) 2
Problem with SET & REF function 0
Outlook 365 overriding formatting choices 0
Time Sum in Excel 1
Multiple IF Statement in Word 5
dragging formula is giving me undesired result in cell calls. 0

Top