AnsweredAssumed Answered

How to round using excel spreadsheet?

Question asked by Alex Lichon on Jul 27, 2015
Latest reply on Jul 29, 2015 by Alex Lichon

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)

Outcomes