More Excel Help

Member 328449

Prominent Member
Hoping this may be quite simple. I have a list of numbers but I want them to be rounded to the nearest 0.5. Is this possible somehow? In format cell I can chose one decimal place but that does to the nearest 0.1


Distinguished Member
=MROUND(<cell ref>, <amount>)

So like:
=MROUND(A1, 0.5)

Member 328449

Prominent Member
Seems to work, only thing is the cells which are blank return the #Value error which I can't seem to get rid of.


Prominent Member
Use an IF statement to only carry out the rounding if the cell has a value, else output an empty string.

Member 328449

Prominent Member
I thought that but can't work it out. Can you spell it out for me please? I'm a bit tired and can't get it right.

The latest video from AVForums

Tribit StormBox Blast Bluetooth Speaker: Review Coming Soon
Subscribe to our YouTube channel
Support AVForums with Patreon

Top Bottom