View original (French)

Excel round to 0.5 up or down

cherif222 Posted messages 6 Status Membre -  
Julbarbo Posted messages 20 Status Membre -
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 réponses

Réponse 1 / 4
Mytå Posted messages 4246 Registration date   Status Contributeur Last intervention   957
 
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