View Single Post
  #2   Report Post  
Biff
 
Posts: n/a
Default

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