Microsoft Excel
Microsoft Excel
(OP)
Folks,
I'm trying to round off figures in microsoft excel but don't know how to go about it. For instance, round off 2387 to 2400. Has anyone any ideas how?
I'm trying to round off figures in microsoft excel but don't know how to go about it. For instance, round off 2387 to 2400. Has anyone any ideas how?






RE: Microsoft Excel
=ROUND(A2,2-LEN(INT(A2)))= 2400
This can be found under excel's help menu.
RE: Microsoft Excel
Hg
Eng-Tips policies: FAQ731-376
RE: Microsoft Excel
CELL A2 = 2387
=ROUND(A2,-2)
or if you want it to only roundup:
=ROUNDUP(A2,-2)
Hope this helps.
RE: Microsoft Excel
Sorted.