Round a figure to the nearest / highest 10,100,500 etc.
If the number is in A2 just use this formula
To round to the NEAREST 500: (eg. 524 rounds to 500)
=ROUND(A2/500,0)*500
To round to the NEXT HIGHEST 500: (eg. 524 rounds to 1000)
=CEILING(A2,500)
By hwsris, June 7, 2009 @ 1:22 pm
Thanks
Any Idea for A2 is Negative Number?
By Jon Peltier, June 7, 2009 @ 2:46 pm
This doesn’t round the value to the nearest X, it rounds it up to the next highest X. This does what your title claims:
=ROUND(A2/500,0)*500
By hwsris, June 8, 2009 @ 5:54 am
Jon Peltier very helpfull for me.
I use the “CEILING(ABS(A2),500)*-1″ in IF formulas.
Thanks.