Roundup value

[J_Kelly]

I am creating a sheet however I need the values of a specific column to roundup. i.e. 3 stays 3, but 3.1 rounds up to 4.

I know this can be done using the ROUNDUP Formula but is there a way to set this so its automatic? If i type in 3.1 or 3.2 it will default round up to 4?

 

[Joe4]

I know this can be done using the ROUNDUP Formula but is there a way to set this so its automatic?

Yes, if you use VBA. You can have code that runs automatically upon manual data entry.
What range to your want this logic applied to?

 

[Fluff]

If you want the values rounded up when typing them in, why not just type in the value want?
The only way for it to happen automatically would be to use VBA which seems overkill in this situation.