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 answers

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

      Also: =FLOOR(A1,0.5)

      Best regards
      5