Question by  Ben (23)

How do you use the roundup function in Microsoft Excel?

I need to understand the formula for using the roundup function in an Excel worksheet.


Answer by  worker8856 (10)

Click in the any blank cell. Then Enter "=ROUNDUP(NUMBER,DIGIT)" NUMBER refers to cell having no req. to roundup] DIGIT refers to decimal precision, 2,3 etc.. e. g. 6. 5283465 to 6. 53)


Answer by  Tech (34)

In the sheet, Right click cell, choose format cells, then choose Number or Currency, there are choice "Decimal places" to set the roundup function.


Answer by  amitkinha (293)

In Excel, the RoundUp function returns a number rounded up to a specified number of digits. It is important to note that the function rounds away from 0. The syntax for the RoundUp function is: RoundUp( number, digits ) "number: is the number to round up and "digits" is the number of digits to round the number up to.


Answer by  PuterGuru (256)

The fomula is RoundUp(number,digits). The number is the number you want to round up and the digits is how many numbers after the decimal to round up.


Answer by  gigo (1706)

The roundup function takes two parameters: the first one is the input field, the second one is the number of digits after the comma to stay.


Answer by  Lakshmi65 (715)

Equal symbol followed formula ROUNDUP(number,num_digits). If num_digits is greater than 0 (zero), then number is rounded up to the specified number of decimal places or vice versa it will get converted.


Answer by  japratt (1687)

Once you do have Microsoft Excel you will need to do a few different things. First you will need to select the words and then right click to enable the function.

You have 50 words left!