ExcelBanter - ROUND UP or DOWN by 0.5

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - ROUND UP or DOWN by 0.5 (https://www.excelbanter.com/excel-discussion-misc-queries/199484-round-up-down-0-5-a.html)

Warren Easton

ROUND UP or DOWN by 0.5

Can someone help please?
Is it possible to round up or down to the nearest 0.5
For example 6.2 would round to 6 and 6.3 would round to 6.5.

Thanks in advance.
--
Regards
Warren

Bob Phillips[_3_]

ROUND UP or DOWN by 0.5

=ROUND(A20*2,0)/2

--
__________________________________
HTH

Bob

"Warren Easton" wrote in message
...
Can someone help please?
Is it possible to round up or down to the nearest 0.5
For example 6.2 would round to 6 and 6.3 would round to 6.5.

Thanks in advance.
--
Regards
Warren

Warren Easton

ROUND UP or DOWN by 0.5

Perfect, Thank You.--

Regards
Warren

"Bob Phillips" wrote:

=ROUND(A20*2,0)/2

--
__________________________________
HTH

Bob

"Warren Easton" wrote in message
...
Can someone help please?
Is it possible to round up or down to the nearest 0.5
For example 6.2 would round to 6 and 6.3 would round to 6.5.

Thanks in advance.
--
Regards
Warren

David Biddulph[_2_]

ROUND UP or DOWN by 0.5

=MROUND(A2,0.5)
Look up MROUND in Excel help if you have problems.
--
David Biddulph

"Warren Easton" wrote in message
...
Can someone help please?
Is it possible to round up or down to the nearest 0.5
For example 6.2 would round to 6 and 6.3 would round to 6.5.

Thanks in advance.
--
Regards
Warren

All times are GMT +1. The time now is 10:15 PM.