View original (French)

CALC - rounded down to the nearest multiple

Solved
litteulced Posted messages 42 Registration date   Status Member Last intervention   -  
DjiDji59430 Posted messages 4278 Registration date   Status Member Last intervention   -

Hello everyone,

I didn't find the answer in the forum or in the CALC help (or at least only a partial answer). I'm looking to get a result rounded down to the nearest MULTIPLE. When I use the formula =ROUND.DOWN.MULTIPLE(AI6;7) it works perfectly but it rounds to the nearest multiple.

For example: if my result is 13 I want it to display 7 and not 14...

Thank you very much for your help!

4 answers

  1.
    eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
     

    Hello,

    =INT(A2/7)*7
    eric

    By constantly trying, we eventually succeed.
    So the more it fails, the more chances we have that it will work. (the Shadoks)
    In addition to saying thank you (yes, it happens!!!), remember to set it to resolved. Thank you

    0
    1. litteulced Posted messages 42 Registration date   Status Member Last intervention  
       

      Correction: Thank you very much Eric, it works

      0
  2. DjiDji59430 Posted messages 4278 Registration date   Status Member Last intervention   717
     

    Hello everyone,

    try:

    =ROUND.MULTIPLE(AI6;7)-7


    Best regards

    0
  3. litteulced Posted messages 42 Registration date   Status Member Last intervention  
     

    Thank you for your responses. None of this is working...

    0
    1. DjiDji59430 Posted messages 4278 Registration date   Status Member Last intervention   717
       

      It works at my place!

      Moreover, it's mathematical.

      On top of that, you announce this without evidence and think we're a bunch of jokers!

      0
  4. litteulced Posted messages 42 Registration date   Status Member Last intervention  
     

    [RESOLVED]

    0