Excel: how to create a multiple of???

Solved
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

  • Votes
  • Date
  • Descending date
  1. 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
    1. Merci beaucoup... je vais essayer, encore une petite question mon Excel est en anglais, "si" devient "if" mais "MOD"??
    2. mod must remain mod, it's the abbreviation of modulo ;)
    3. Thank you very much... I'm really bad at Excel...
    4. Problem solved! A big thank you...