Showing posts with label office. Show all posts
Showing posts with label office. Show all posts

Thursday, June 7, 2007

RoundToNearest in Microsoft Excel

This will round the given cells to the nearest number given, pretty neat if you want to produce a repost that is rounded, e.g. to the 0.25.


=IF(C50>0,CEILING(C50,0.25),-CEILING(C50,0.25))