Prev: Identify the windows just below the menu
Next: Finding the lowest cost for a product from a list
From: Billy B on 16 Apr 2010 10:27
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.
From: T. Valko on 16 Apr 2010 10:42
Try it like this...

="Total is: "&ROUND(SUM(B96:B104),2)

--
Biff
Microsoft Excel MVP


"Billy B" <BillyB(a)discussions.microsoft.com> wrote in message
news:00B24B07-2B51-493E-B199-7BBA2860D044(a)microsoft.com...
>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.


From: Squeaky on 16 Apr 2010 11:09
Hi Billy,

Try using the ROUND function.

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

Omit the spaces around the &.

Squeaky

"Billy B" wrote:

> 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.
From: "David Biddulph" groups [at] on 16 Apr 2010 12:53
The function is TEXT, not FORMAT
--
David Biddulph


"Billy B" <BillyB(a)discussions.microsoft.com> wrote in message
news:00B24B07-2B51-493E-B199-7BBA2860D044(a)microsoft.com...
> 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.


 | 
Pages: 1
Prev: Identify the windows just below the menu
Next: Finding the lowest cost for a product from a list