 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / May 2008Number Format?
I have entered the following in cell A1 ="Average "&AVERAGE(D:D) and the value I get is Average 47.247619047619. How can I round down to 1 decimal place? I have tried number format but it does not make a difference :-( Try this: A1 ="Average "&TEXT(AVERAGE(D:D),"0.0") Does that help? Post back if you have more questions. -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) > I have entered the following in cell A1 ="Average "&AVERAGE(D:D) > and the value I get is Average 47.247619047619. > How can I round down to 1 decimal place? > I have tried number format but it does not make a difference > :-( Perfect Many Thanks :-) > Try this: > [quoted text clipped - 15 lines] > > I have tried number format but it does not make a difference > > :-( Maybe ="Average "&TEXT(AVERAGE(D:D),"0.00") Mike > I have entered the following in cell A1 ="Average "&AVERAGE(D:D) > and the value I get is Average 47.247619047619. > How can I round down to 1 decimal place? > I have tried number format but it does not make a difference > :-( You wanted 1 decimal place so ="Average "&TEXT(AVERAGE(D:D),"0.0") Mike > I have entered the following in cell A1 ="Average "&AVERAGE(D:D) > and the value I get is Average 47.247619047619. > How can I round down to 1 decimal place? > I have tried number format but it does not make a difference > :-( Try this ="Average "&ROUND(AVERAGE(D:D),2) >I have entered the following in cell A1 ="Average "&AVERAGE(D:D) > and the value I get is Average 47.247619047619. > How can I round down to 1 decimal place? > I have tried number format but it does not make a difference > :-( If you want to physically round the value to one decimal place (that is, reduce its accuracy), then you have your answer in the other postings in this thread. However, if you only want to display it to one decimal place, but keep its full accuracy (perhaps for other calculations), then leave keep your formula but Custom Format the cell (right click the cell and select Format Cells) using 0.0 as the pattern. Rick >I have entered the following in cell A1 ="Average "&AVERAGE(D:D) > and the value I get is Average 47.247619047619. > How can I round down to 1 decimal place? > I have tried number format but it does not make a difference > :-( Are you sure, Rick? What effect does that have when the formula gives a text result? -- David Biddulph > If you want to physically round the value to one decimal place (that is, > reduce its accuracy), then you have your answer in the other postings in [quoted text clipped - 10 lines] >> I have tried number format but it does not make a difference >> :-( Sooo, that is why everyone gave the TEXT function solution.<g> I read too fast... totally missed the "Average "& part of his formula. Thanks for catching that. Rick > Are you sure, Rick? What effect does that have when the formula gives a > text result? [quoted text clipped - 15 lines] >>> I have tried number format but it does not make a difference >>> :-( On Thu, 8 May 2008 12:38:11 -0400, "Rick Rothstein \(MVP - VB\)" <rick.newsNO.SPAM@NO.SPAMverizon.net> wrote: >If you want to physically round the value to one decimal place (that is, >reduce its accuracy), then you have your answer in the other postings in [quoted text clipped - 4 lines] > >Rick I don't believe that will work since his formula is a concatenation of strings. However, if he changed his formula to : =AVERAGE(D:D) And then used the Custom Format: "Average "0.0 the result would be as he might want. --ron Yes, David caught that too. I read the OP's post too fast (carelessly) and missed the "Average "& part of his formula. Your suggestion is probably what I would have offered had I read the posting more carefully. Thanks for posting it. Rick > On Thu, 8 May 2008 12:38:11 -0400, "Rick Rothstein \(MVP - VB\)" > <rick.newsNO.SPAM@NO.SPAMverizon.net> wrote: [quoted text clipped - 22 lines] > the result would be as he might want. > --ron Perfect Many Thanks :-) > I have entered the following in cell A1 ="Average "&AVERAGE(D:D) > and the value I get is Average 47.247619047619. > How can I round down to 1 decimal place? > I have tried number format but it does not make a difference > :-( Perfect Many Thanks :-) > I have entered the following in cell A1 ="Average "&AVERAGE(D:D) > and the value I get is Average 47.247619047619. > How can I round down to 1 decimal place? > I have tried number format but it does not make a difference > :-( Many Thanks :-) > I have entered the following in cell A1 ="Average "&AVERAGE(D:D) > and the value I get is Average 47.247619047619. > How can I round down to 1 decimal place? > I have tried number format but it does not make a difference > :-( |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.