I am making a design table in excel. For modeling purposes, I have the exact lengths of my material in one column i.e. 1.125, 1.375, 1.50, 1.625, 1.75, 1.875, 2.00 etc. Then I am using a formula to put those exact values into a part description, however the description must be rounded as follows: 1.12, 1.38, 1.50, 1.62, 1.75, 1.88, 2.00 etc. How do I do this in excel for an entire column? (notice how some round up and some round down depending in the odd or even number before the 5)

I had not seen these replies until just now. In the mean time another employee of ours came up with this equation:

=TEXT((ROUND(((EVEN((TRUNC(A1/2,3))*1000))*0.002),2)), "0.00")

The text function was used because we needed to use the final value in a CONCATENATE function and that only reads text (the column itself could not be changed to text in this instance). The text was also kept to 0.00 places, which our part description also needed to be kept at.

Thank you very much for your other responses!