How can we help you today?

Search for answers to your questions by entering keywords below, or look through our knowledge base.

Welcome to 'Sikkhon' User Forum

Thanks for visiting our Forum. It provides an opportunity for our visitors/users to interact with out team and fellow visitors/users. You can find further resources in Knowledge Base and tutorials. Please don't submit any personal or confidential info here, instead create a ticket.

How to round numbers in Excel function

Posted 12 months ago by Alamin Amin Hossain

Un Answered
Alamin Amin Hossain

hi,

You can use round function to make long decimal numbers  to a specified number of digits in ms excel.

in ms excel has many different ways to round a cell value. 


For example: 

if your cell contains 29.36585, and you want to round that value to two decimal like  29.37 you can simply use below function for that. 


=ROUND(29.36585 , 2)


When you try to use round function you will get 2 Syntax


1 - number:  The number/Cell that you want to round.

2 - num_digits:  The number of digits to which you want to round the number argument.


If you want to round a cell after calculatng with the SUM() function you should use following function.


=SUM(ROUND(A1 , 2)) 


To know more about it please watch the video 


If you have question on that topic please reply us or visit sikkhon.com to learn more


0 Votes


0 Comments

Login or Sign up to post a comment