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?
Your requirement:
Solution:
=MAX(200, value)
If you wanted everything under 200 rounded to 200, and everything else left alone:
=IF(CELL<200, 200, CELL);
'CELL' being the coordinate.
If you literally wanted just the range from 1-200 to be rounded to 200, and not values less than 1, as your original question specifies:
=IF(cell<200, IF(cell<1, cell, 200), cell)
This will satisfy your stated requirements.