percentile help

[browndog]

I'm trying to get the percentiles for every 1% from 0-100. I have a column with the numbers 0, .01, .02, .03...etc all the way up to 1. The data set is b2:b80 and I was able to get the 1st percentile by using the percentile function and having b2:b80 as array and d2 (which is the box with .01 in it) for k. This is the function I used =PERCENTILE.INC(B2:B80,D2) However, when I click and drag that box down it the box below it changes to =PERCENTILE.INC(B3:B81,D2), when I want it to change to =PERCENTILE.INC(B2:B80,D3). What am I doing wrong?
Thanks

[Sofistikat]

=PERCENTILE.INC($B$2:$B$80,$D2)

....and then drag/copy that down.

[browndog]

thank you!!