Excel Exercise


I came across a comment on this page from Lance Ng, that asked for a rounding function with the following properties:

If decimal in cell more than 0.20 = 0.50;
If decimal in cell more than 0.50 = 1;
If decimal in cell less than 0.20 = 0

So a number that should not just be rounded up or down, but also rounded to 0.5 when the decimal portion of the number is between 0.2 and 0.5.

Without further ado, here it is:

Spreadsheet editor

For more Excel exercises, check out our Spreadsheet Playground.

​Get Good at Excel on Autopilot

Sign up to our newsletter and receive ​Excel articles, tips and tricks delivered straight to your inbox. All you have to do is read them! ​Plus, to get you started, you'll receive a PDF with 200+ Excel shortcuts.