View original (French)

Excel round to 0.5 up or down

cherif222 Posted messages 6 Status Member -  
Julbarbo Posted messages 20 Status Member -
Hello,

I would like to round a range of numbers to the nearest 0.5, for example:

numbers between 3.75 and 4.24 -> 4.0
numbers between 4.25 and 4.74 -> 4.5
etc

Thank you very much for your help!

Excel Mac 2011, version 14.1.4

Configuration: Mac OS X / Safari 534.52.7

4 answers

  1.
    Mytå Posted messages 4246 Registration date   Status Contributor Last intervention   958
     
    Hello forum 

    =ROUND(A1/5;1)*5

    Mytå
    --
    What arrogance to claim that computing is recent
    Adam and Eve already had an Apple! [MsProject 2003(EN), Excel 2003-2007(EN)]
    4