More Excel Help

Member 328449

Prominent Member
Joined
Aug 31, 2007
Messages
3,464
Reaction score
346
Points
940
Location
Kent
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
 
Try:
=MROUND(<cell ref>, <amount>)

So like:
=MROUND(A1, 0.5)
 
Seems to work, only thing is the cells which are blank return the #Value error which I can't seem to get rid of.
 
Use an IF statement to only carry out the rounding if the cell has a value, else output an empty string.
 
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.
 
Something like:

=IF(<cell ref> != "", MROUND(<cell ref>, 0.5), "")

Which basically means - IF( condition, [value_if_true], [value_if_false] )

That is based on the assumption that the cell you want to round is blank.

If you want more explanation - https://support.microsoft.com/en-us/kb/214244, although bear in mind that the example evaluates an integer value. Or - MS Excel: IF Function (WS)
 
Spot on, thanks.
 

The latest video from AVForums

Is 4K Blu-ray Worth It?
Subscribe to our YouTube channel
Back
Top Bottom