code_junkie

Where to find out the method used for excel functions

Nov 12th, 2011
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.48 KB | None | 0 0
  1. A B C D
  2. 1 1 0% 1 =PERCENTILE($A$1:$A$6,B1)
  3. 2 2 20% 2 =PERCENTILE($A$1:$A$6,B2)
  4. 3 3 40% 3 =PERCENTILE($A$1:$A$6,B3)
  5. 4 4 60% 4 =PERCENTILE($A$1:$A$6,B4)
  6. 5 5 80% 5 =PERCENTILE($A$1:$A$6,B5)
  7. 6 6 100% 6 =PERCENTILE($A$1:$A$6,B6)
  8. 7
  9. 8 10% 1.5 =PERCENTILE($A$1:$A$6,B8)
  10. 9 11% 1.55 =PERCENTILE($A$1:$A$6,B9)
  11. 10 12% 1.6 =PERCENTILE($A$1:$A$6,B10)
Add Comment
Please, Sign In to add comment