How do you round off a number in Microsoft excel?
Microsoft excel help please?norton internet security You need to use the Round function. The round function has 2 parameters. Parameter 1 is the number you would like to round. Parameter 2 is the decimal place you would like to round it to.
Round(yournumber, deceimal place to round it to)
for example:
Round (1.5, 0) = 2
Round (1.555, 2) = 1.56
Round(1.5555, 3) = 1.556
Microsoft excel help please?spyware remove Go to Format, number, and change the number of decmal places and it will do it automaticly.
Great Question and Good luck
Use the Round() function. Inside the brackets you need two values, the number to be rounded and the number of decimal places to round off to. Use 0 for to round to nearest whole integer.
Use =ROUND(A2,0)
There are several formulas to do that which produce different results.
=ROUND(cell,0) will round the number to the nearest number.
=ROUNDDOWN(cell,0) will always round down
=ROUNDUP(cell,0) will always round up
So if you have 20.3 in A1 and do =ROUND(A1,0), that will return 20. If you do =ROUNDDOWN(A1,0), that will return 20. And if you do =ROUNDUP(A1,0), that will return 21.
Furthermore, if you have 20.34 in A1 and do =ROUND(A1,1), that will return 20.4. The same syntax applies to the other examples.
Formula Description (Result)
=ROUNDUP(A2,0) Rounds 20.3 up to the nearest whole ^^^^^^^^^^^^^^^^^^ number (21)