Query Regarding Round Off Formula In Excel Tips

Asked By John K Ditto 20 points N/A Posted on - 06/15/2017

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.

• Status: Open
• Question Views: 393
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel
• Question Tags: Excel | round off formula

Answered By knowles cooke 10 points N/A #299408

Query Regarding Round Off Formula In Excel Tips

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.

About knowles cooke

Questions
18

Answers
3

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 06/15/2017
• Question Category: MS Excel