The general formula for rounding up values in Excel is:
To round a number up to any decimal places using excel, the ROUNDUP function is used to return the rounded number to the number of digits specified.
Figure 1. Rounding up Euler’s number using excel
The formula in cell G8 is
This formula tells Excel to take the Euler’s number in cell E8 and round it to the number of digits in cell F8 (3) with a result of 2.72.
Notice that even though the 2nd digit after the decimal in 2.718282 is one, but it is still returned (rounded up) as 2.
From the example shown, the ROUNDUP function is used to round Euler’s number to a descending order of digits, starting at 5 and moving down past zero to -2.
Note that positive digits round to the right of the decimal point, while negative digits and zero are rounded to the left.