Excel 2007 : Rounding #'s

[ddodson]

Hello, I have a column that has number ranging from 70-150. I need the next column to round the numbers to 100 if they are 100 or higher, and if lower than 100, keep it the same.

Example:

133 - will be 100
129 - will be 100
101 - will be 100
79 - will be 79

How do I formulate this?

[DonkeyOte]

You can use MIN:

Please Login or Register  to view this content.

which will take the lesser of the two values

[ddodson]

That did the trick...Thanks!