 |
 | 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 / New Users / March 2008Converting percentiles to quintiles
This sounds silly, but I have a column of data with percentile values (i.e., 1 to 100) and I'd like to create a matching column showing what quintile each one is in. Eg, if the percentile value is between 0-20 it's in the first quintile, 20-40, in the second, etc.). Is there any easy way to do this other than a big nested IF statement? If so, thanks! Assuming your data starts in A1, put this formula in B1: =INT((A1-1)/20)+1 and copy down. Hope this helps. Pete > This sounds silly, but I have a column of data with percentile values > (i.e., 1 to 100) and I'd like to create a matching column showing what [quoted text clipped - 3 lines] > Is there any easy way to do this other than a big nested IF statement? > If so, thanks! > Assuming your data starts in A1, put this formula in B1: > [quoted text clipped - 13 lines] > > Is there any easy way to do this other than a big nested IF statement? > > If so, thanks! Thanks very much -- that works perfectly. I also tried it using the TRUNC function, which seems to work. Thanks again. You're welcome - thanks for feeding back. Pete > Thanks very much -- that works perfectly. I also tried it using the > TRUNC function, which seems to work. Thanks again
|
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.