If a value is less than 200, then it should be rounded up to 200.
How do you do this in Microsoft Excel?
If a value is less than 200, then it should be rounded up to 200. How do you do this in Microsoft Excel? 


Below formula helps



Your requirement:
Solution:



If you wanted everything under 200 rounded to 200, and everything else left alone:
'CELL' being the coordinate. If you literally wanted just the range from 1200 to be rounded to 200, and not values less than 1, as your original question specifies:
This will satisfy your stated requirements. 

