Rounding but different example

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.

Leave a Comment