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))
Posted by at
Labels:

1 comment:

  1. AlexisOctober 6, 2009 at 8:54 PM

    This comment has been removed by a blog administrator.

    ReplyDelete

[Due to much spam, comments are now moderated and will be posted after review]

Note: Only a member of this blog may post a comment.

Subscribe to: Post Comments (Atom)