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:00B24B072B51493EB1997BBA2860D044(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:00B24B072B51493EB1997BBA2860D044(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 