Back to your question at hand, let me preface everything by saying that this function works on Excel and Google Docs. I'm not sure if it works on Works (pun unintended), but I'm pretty sure it will as this is a basic spreadsheet function and requirement.
First of all, I understand that your requirement is to "round" all numbers with decimals fractions UP to the next integer. Please note that I actually used the term "round" based on your question. Technically, though, rounding has been defined as rounding either UP or DOWN, depending on which integral value was closer, up or down; with the halfway value rounded UP, even though technically it is the same distance from the lower integer value. To wit:
2.0 rounds to 2
2.01 rounds to 2
2.2 rounds to 2
2.49 rounds to 2
2.5 rounds to 3
2.8 rounds to 3
However, your question indicates that
2.0 "rounds" to 2
2.01 "rounds" to 3
2.2 "rounds" to 3
2.49 "rounds" to 3
2.5 "rounds" to 3
2.8 "rounds" to 3
That is the fundamental difference of the functions. In fact, the two excel / google docs formulas are as follows:
ROUND(number)
and
INT(number)
ROUND performs exactly in the first example; ie, rounding up or down, depending on how close it is to the upper or lower integer value.
INT, however, actually "truncates" the fraction off of the number, no matter how high it is. Therefore,
2.0 truncates to 2
2.01 truncates to 2
2.2 truncates to 2
2.49 truncates to 2
2.5 truncates to 2
2.8 truncates to 2
This is closer. At first glance, it appears that the problem is solved; just add 1 to the result and come up with the rounded number. But 2.0 should not have a number added. Therefore, we need to check to see if there is a fractional value present on the number. Therefore, we have to introduce one more function into the mix, the IF function.
Basically, the IF function evaluates an expression. If an expression is true, the function will process one statement. If the expression is false, then the function will process another statement.
Therefore, going back to the earlier numbers, let's check the expressions above
INT(2.0) = 2.0 evaluates to TRUE
INT(2.01) = 2.01 evaluates to FALSE
INT(2.2) = 2.2 evaluates to FALSE
INT(2.49) = 2.49 evaluates to FALSE
INT(2.5) = 2.5 evaluates to FALSE
INT(2.8) = 2.8 evaluates to FALSE
Now for the IF function. The format is like this:
IF("expression", "result if expression is true", "result if expression is false")
Here is the IF function in use. If the expression is true, the color is red. Otherwise, it's blue.
IF(INT(2.0) = 2.0, "RED", "BLUE") evaluates to RED
IF(NT(2.01) = 2.01, "RED", "BLUE") evaluates to BLUE
IF(NT(2.2) = 2.2, "RED", "BLUE") evaluates to BLUE
IF(NT(2.49) = 2.49, "RED", "BLUE") evaluates to BLUE
IF(NT(2.5) = 2.5, "RED", "BLUE") evaluates to BLUE
IF(NT(2.8) = 2.8, "RED", "BLUE") evaluates to BLUE
You can use mathematical functions as True / False statements as well. So to finish off (assume your number is located in cell A1):
IF(INT(A1) = A1, A1, A1+1)
That should do the trick for you. Substitute A1 for other cell values.
