| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text in a combined spreadsheet | Excel Discussion (Misc queries) | |||
| Formual error with text and calc | Excel Discussion (Misc queries) | |||
| Figures and text combined | Excel Worksheet Functions | |||
| text and number combined in a cell | Excel Worksheet Functions | |||
| text and values combined in one cel | Excel Discussion (Misc queries) | |||
Linear Mode
