Excel: how to create a multiple of???
Solved
Ricalaur
-
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.
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
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
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
Ricalaur
Merci beaucoup... je vais essayer, encore une petite question mon Excel est en anglais, "si" devient "if" mais "MOD"??
Stringman621
Posted messages
1726
Registration date
Status
Member
Last intervention
340
mod must remain mod, it's the abbreviation of modulo ;)
Ricalaur
Thank you very much... I'm really bad at Excel...
Ricalaur
Problem solved! A big thank you...