Round Numbers In Excel

[Solved] Round Numbers In Excel | Basic - Code Explorer | yomemimo.com
Question : round numbers in excel

Answered by : santhosh-kumar-dhanasekaran

Here are some examples you could use:
=ROUND(A1,1) // Round to 1 decimal place
=ROUND(A1,2) // Round to 2 decimal places
=ROUND(A1,3) // Round to 3 decimal places
=ROUND(A1,4) // Round to 4 decimal places
=ROUND(A1,0) // Round to nearest whole number
=ROUND(A1,-1) // Round to nearest 10
=ROUND(A1,-2) // Round to nearest 100
=ROUND(A1,-3) // Round to nearest 1000
=ROUND(A1,-4) // Round to nearest 10000
=ROUND(A1/B1,0) // round result to nearest integer

Source : https://exceljet.net/excel-functions/excel-round-function | Last Update : Sun, 04 Apr 21

Answers related to round numbers in excel

Code Explorer Popular Question For Basic