Modify a formula
 

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","")

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

"Eintsein_mc2" wrote in message
ups.com...
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","")

Another option:

=LCM(61,84)
5124

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

HTH
--
Dana DeLouis
Win XP & Office 2003


"Eintsein_mc2" wrote in message
ups.com...
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","")

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