text & formual problem combined
 

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

text & formual problem combined
 

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" wrote in message
...
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

text & formual problem combined
 

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

text & formual problem combined
 

="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

text & formual problem combined
 

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

text & formual problem combined
 

="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

text & formual problem combined
 

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