EXCELlent Ones Consulting Skip to Content Skip to Search

Print  |   | Download PDF


This function rounds a number to a specified number of digits. Below we have a number in need of rounding.

1. The syntax for the Round function is Round(number, Num_digits)

a. Number: This would be the number in need of rounding

b. Num_digits: This would be the number of digits to be rounded off

2. The examples show different function scenarios using varying Num_digits

a. Notice, specifying a negative number will round off number before the decimal point

b. Notice, specifying a positive number will round off numbers after the decimal point


Email: info@excellentones.com | P.O. Box 160493 | Brooklyn, NY 11216 | Phone: (347) 763-1035 | Fax: (718) 228-7859

All rights reserved. Copyright 2014 Excellent Ones Consulting LLC.