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.
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