Learn how to calculate all the particulars of a loan using Excel and how to set up a schedule of repayment for a mortgage or any other loan.

Start Excel and open the worksheet containing the number you want to round up. Click inside of the cell where you want to display the calculation. Type "=ROUNDUP ()" into the formula bar.