Nir Levy - Eureka
-- work overload --
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))
Older Posts
Home
Subscribe to:
Posts (Atom)