Question. I used this IF statement =IF(ISEVEN(ROUNDUP(U14,0)),ROUNDDOWN(U14,0),ROUNDUP(U14,0))-1 to round down both even numbers w/ decimal point and tenths and odd numbers to the nearest whole even number. Works perfectly. However, if the cell populates with a whole even number, it will substract 1 creating an odd number instead of leaving it as is. I'm not sure what to add or re-write to account for whole numbers when populated.

How about if the ones digit is even while the tenth digit is greater than 5. Say, 102.9. How can it be rounded off correctly?

Hi, I need help getting my desired decimal number after doing an average of 4 cells. The average number gives me an unwanted decimal number both in MS Excel and Google Sheet. E.g First, I want .00 to .24 as the round number (Like: The average is 112.15, which should be 112.00), Then, .24 to .75 as .50 (Like: The average is 112.34, which should be 112.50), Finally, .76 to .99 as the next rounded number (Like: The average is 112.82, which should be 113.00). It would be a great favor, if you reply me with the formula for this problem. Have a great day. Thank you.