View original (French)

Round up to the nearest 0.5 in Excel

Solved
mouchadawa -  
 toto -
Hello,

I would like to know the formula to round up to the nearest 0.5 for the accounting of my store's products. Example:

8.00 -> 8
8.01 -> 8.5
8.27 -> 8.5
8.49 -> 8.5
8.50 -> 8.5
8.51 -> 9
8.99 -> 9
9.00 -> 9
9.01 -> 9.5
...etc

Thank you for your help, it's quite urgent!! :)

Configuration: Windows 7 / Internet Explorer 8.0

5 réponses

Réponse 1 / 5
Raymond PENTIER Posted messages 58545 Registration date   Status Contributeur Last intervention   17 474
 
B2=CEILING(A2*2;0)/2
--
It's great, retirement! Especially in the Antilles... :-)
☻ Raymond ♂
131
Laure
 
Thank you very much!
1
ALS35 Posted messages 1034 Registration date   Status Membre Last intervention   147 > Raymond PENTIER Posted messages 58545 Registration date   Status Contributeur Last intervention  
 
Hello,

Also: =FLOOR(A1,0.5)

Best regards
5