How to Round Up Numbers in Microsoft Excel

Sometime we need to round up numbers before we move to complex calculation. But rounding up thousands of rows manually is impossible and the rounding data up is very important. That's why excel has a function to round up data. In this tutorial i'm going to show you how you can use ROUND UP function to round up data in excel.

Simply Write =Roundup(A1,2)

Here A1 is the cell no where you have data that need to be rounded up and 2 indicates how many digit you'll get after (.).

#roundup #function
Thanks for watching.
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial

Playlists:

Social media:

[wanasaraf]

Hi, I am unable to get my desired decimal number after doing an average of 4 cells. The average number gives me an unwanted decimal number. E.g First, I want .00 to .24 as the round number (Like: The average is 112.15, which should be 112.00), Then, .24 to .75 as .50 (Like: The average is 112.34, which should be 112.50), Finally, .76 to .99 as the next rounded number (Like: The average is 112.82, which should be 113.00). It would be a great favor, if you reply me with the formula for this problem. Have a great day. Thank you.