Modify a formula

E

Eintsein_mc2

This is showing how much of a novice I am, but I'm learning. I need to
change this formula so that it not only shows the message if multiples
of 84 is not entered but if multiples of 61 is not entered into the
same cell. Thanks.
=IF(MOD(F21,84)<>0,"Qty in this Row is not in multiples of 84","")
 
B

Biff

Hi!

Try this:

=IF(MOD(F21,84)=0,"",IF(MOD(F21,61)=0,"","Qty in this Row is not in
multiples of 84 or 61"))

Biff
 
D

Dana DeLouis

Another option:

=LCM(61,84)
5124

then...
=IF(MOD(A1,5124)=0,"","Qty not mul of 61 or 84")

HTH
 
E

Eintsein_mc2

Thanks Guys. Works perfect. I don't know what I would do with out
people like you helping me, Thanks again
 
Top