microsoft excel
 

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.