View original (French)

Excel: how to create a multiple of???

Solved
Ricalaur -  
 Ricalaur -
Hello,
A quick question for those knowledgeable in Excel.
I need to set an alert in a cell every time the number in it is not a multiple of six.
Can anyone help me formulate this?
Thank you very much in advance, I'm struggling...
Laurence.

2 answers

  1.
    Stringman621 Posted messages 1726 Registration date   Status Member Last intervention   340
     
    Hello,

    That should work for you:

    =IF(MOD(A1,6)<>0,"not a multiple of 6","multiple of 6")

    Knowing that I tested it on cell A1

    See you later

    --
    less a quarter: RICARD, less 10: PASTIS
    Founding member of the FJH
    7
    1. Ricalaur
       
      Merci beaucoup... je vais essayer, encore une petite question mon Excel est en anglais, "si" devient "if" mais "MOD"??
      0
    2. Stringman621 Posted messages 1726 Registration date   Status Member Last intervention   340
       
      mod must remain mod, it's the abbreviation of modulo ;)
      0
    3. Ricalaur
       
      Thank you very much... I'm really bad at Excel...
      0
    4. Ricalaur
       
      Problem solved! A big thank you...
      0