Prev: how do i weight a series of rankings in excel?
Next: What if I forgot the password protecting an excel workbook?
From: David Biddulph groups [at] on 9 Mar 2010 10:23
="Avg "&TEXT(D30,"0.00")
--
David Biddulph


"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:34
Maybe: ="AVG " & TRUNC(D30,2)
Micky


"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
First  |  Prev  | 
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?