Looking For An Excel Formula To Round Up Digits.

Asked By Gianetta 0 points N/A Posted on - 07/26/2016

Hello all,

I have made an Excel File, which deals with many Values. I am in search of a Formula or a Function that I can use to Round Up all the values.

Someone, tell me the Excel Formula to Round Up digits.

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

• Answer Accepted: No
• Question Category: MS Excel

Answered By Cabigas Medina 0 points N/A #107106

Looking For An Excel Formula To Round Up Digits.

You can use the Excel Round Up function to Round a number up away from Zero.

The syntax to use the function is “ROUNDUP (digit, no. of decimal places).

” For e.g. if you want to use the function on 3.1469 up to three Decimal Places, then the syntax will be “ROUNDUP(3.1469,3)”.

You can use it like any other Formula or Function of MS Excel.

About Cabigas Medina

Questions
15

Answers
8

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 07/26/2016
• Question Category: MS Excel