huangyhg

microsoft excel
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?
check out our whitepaper library.
cell a2 = 2387
=round(a2,2-len(int(a2)))= 2400
this can be found under excel's help menu.
for future reference, try
or you can try this:
cell a2 = 2387
=round(a2,-2)
or if you want it to only roundup:
=roundup(a2,-2)
hope this helps.
thanks guys,
sorted.

__________________
借用达朗贝尔的名言：前进吧，你会得到信心!
[url="http://www.dimcax.com"]几何尺寸与公差标准[/url]