View original (French)

Round in Excel to 0.99

Solved
Claudio34 -  
 Claudio34 -
Hello,

For a pricing table, I would like to know which formula to use so that all my prices below .50 are rounded down to the nearest .99 and all those equal to or above .50 are rounded up to the nearest .99?

E.g.: 4.45 € => 3.99 € and 4.51 € => 4.99 €

Thank you

Claude

Configuration: Mac OS X (10.11.5) / Safari 9.1.1

2 answers

  1.
    via55 Posted messages 14393 Registration date   Status Member Last intervention   2 759
     
    Hello Claude

    With in A1 your price, in B1 the formula: =ROUND(A1;0)-0.01

    Best regards
    Via

    --
    "Imagination is more important than knowledge." A. Einstein
    3
    1. Claudio34
       
      Thank you Via! Indeed, yours works!!

      Great! Really, thank you again!

      Claude
      0
  2. PHILOU10120 Posted messages 6463 Registration date   Status Contributor Last intervention   835
     
    Hello claudio34

    Try this

    =ROUND.ME.UP.MULTIPLE(A1;0.998)

    --
    It is by forging that one becomes a blacksmith. - It is at the foot of the wall that one sees the mason - one always learns from their mistakes
    0
    1. Claudio34
       
      Thank you Philou, but apparently, it doesn't work!
      0