Prev: how do i weight a series of rankings in excel?
Next: What if I forgot the password protecting an excel workbook?
From: David on 9 Mar 2010 09:40
When I combine text and a formula - i.e. ="Avg "& SUM(D30) - it comes out as
Avg 0.286253661284266 but I only want it to 2 decimal points!

The D30 cell contains the simple formula for £152458.70 divided by 532,600

Can someone explain or show me how I can produce an answer to 2 decimal
points as "Avg 0.28"?

Thanks
From: Luke M on 9 Mar 2010 09:52
Something similar to:

="Avg "&TEXT(SUM(D30),"$#.00")


You need to use the TEXT function to format the formula portion.

--
Best Regards,

Luke M
"David" <David(a)discussions.microsoft.com> wrote in message
news:3575BA87-0660-4E61-9590-022B744F9C4A(a)microsoft.com...
> When I combine text and a formula - i.e. ="Avg "& SUM(D30) - it comes out
> as
> Avg 0.286253661284266 but I only want it to 2 decimal points!
>
> The D30 cell contains the simple formula for �152458.70 divided by 532,600
>
> Can someone explain or show me how I can produce an answer to 2 decimal
> points as "Avg 0.28"?
>
> Thanks


From: Russell Dawson on 9 Mar 2010 09:56
Make your entry simply =SUM(D30)

Then custom format cell to read "Ave" 0.00

Result to 2 places is .29
--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"David" wrote:

> When I combine text and a formula - i.e. ="Avg "& SUM(D30) - it comes out as
> Avg 0.286253661284266 but I only want it to 2 decimal points!
>
> The D30 cell contains the simple formula for £152458.70 divided by 532,600
>
> Can someone explain or show me how I can produce an answer to 2 decimal
> points as "Avg 0.28"?
>
> Thanks
From: Teethless mama on 9 Mar 2010 10:10
="Avg "&ROUND(D30,2)


"David" wrote:

> When I combine text and a formula - i.e. ="Avg "& SUM(D30) - it comes out as
> Avg 0.286253661284266 but I only want it to 2 decimal points!
>
> The D30 cell contains the simple formula for £152458.70 divided by 532,600
>
> Can someone explain or show me how I can produce an answer to 2 decimal
> points as "Avg 0.28"?
>
> Thanks
From: מיכאל (מיקי) אבידן on 9 Mar 2010 10:21
He stated, very clearly, that he expects: Avg 0.28 that means NOT Avg 0.29
Micky


"Teethless mama" wrote:

> ="Avg "&ROUND(D30,2)
>
>
> "David" wrote:
>
> > When I combine text and a formula - i.e. ="Avg "& SUM(D30) - it comes out as
> > Avg 0.286253661284266 but I only want it to 2 decimal points!
> >
> > The D30 cell contains the simple formula for £152458.70 divided by 532,600
> >
> > Can someone explain or show me how I can produce an answer to 2 decimal
> > points as "Avg 0.28"?
> >
> > Thanks
 |  Next  |  Last
Pages: 1 2
Prev: how do i weight a series of rankings in excel?
Next: What if I forgot the password protecting an excel workbook?