| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Displaying Percentiles
Hello, I need to display percentiles based on vlues I input, but I am limited to 7 nested IF statements. Could somebody show me a way to do this which will allow me to display the percentiles from 99% to 1%? Here is what I have right now: =IF(F3<6.68,"99"%,IF(F3<7.09,"98"%,IF(F3<7.72,"97" %,IF(F3<7.77,"96"%,IF(F3<8.1,"95"%,IF(F3<8.44,"94" %,IF(F3<8.96,"93"%,IF(F3<9.14,J3)))))))) thanks, Mike -- Michael L ------------------------------------------------------------------------ Michael L's Profile: http://www.excelforum.com/member.php...o&userid=27787 View this thread: http://www.excelforum.com/showthread...hreadid=538996 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| TRIMMEAN with different percentiles? | Excel Worksheet Functions | |||
| functions are not displaying the results | Excel Worksheet Functions | |||
| Charting: Displaying cumulative totals at top of stacked columns | Charts and Charting in Excel | |||
| Fonts not displaying correctly | Excel Discussion (Misc queries) | |||
| when displaying formulas, how to start a new line in the same cel. | Excel Discussion (Misc queries) | |||
Threaded Mode
