Round to Nearest Whole
Number
The Round to Nearest Whole Number function rounds values in a time series or
paired data set to the nearest whole number.
The function rounds up the decimal portion of a number if equal to or greater than .5 and rounds down decimal values less than .5. For example:
| 10.5 | is rounded to 11. | |
| 10.499 | is rounded to 10. | |
| -10.499 | is rounded to -10. | |
| -10.500 | is rounded to -10. | |
| -10.501 | is rounded to -11. |
The x-values in paired data sets are unaffected by the function, only the y-value data are rounded. For time series data sets, missing values are kept missing.
To round values in time series or paired data sets to the nearest whole number: