I want to round up and down numbers in Excel. I don’t know the formula or the command to do it. Can someone tell me the round off formula in Excel? Need urgent help.
The formula for rounding​ of numbers in Excel are-
ROUND(num, num_digit)- num-number to be round off, num_digit- number of places to be rounded to.
ROUNDUP(num, num_digit)- this rounds the number always up and to the digit specified.
ROUNDDOWN(num, num_digit)- this always rounds the number down up to the digit specified.
These are the formulas used to round off numbers in Excel.
