My formula assumes your numbers are integers (such as 39, 62, 78, etc.). Can
you give some examples of the actual numbers you have in Column A and show
us how the cells are formatted.

--
Rick (MVP - Excel)


"BLR" wrote in message
...
That did not seem to work. I just got 10 returned back in every row. I
checked to see if it was adjusting each row and it was.

"Rick Rothstein" wrote:

Does putting this formula in B1 and copying down give you what you want?

=10*INT(A1/10)

Change the A1 to A2 and put the formula in B2 if you have a header row.

--
Rick (MVP - Excel)


"BLR" wrote in message
...
In column A I have a list of nuimbers. I ran a conditional format to
highlight certain ranges of percentiles (above 80% and above 90%). Is
there
a way to get column B to acutally display what the percentile is?