Why not just have them enter the number of lots instead? Then have your
formula multiply it by 66.
************
Anne Troy
www.OfficeArticles.com

"Eintsein_mc2" wrote in message
oups.com...
I have a worksheet that is a quote form for quoting on bricks. Bricks
are only avaliable in lots of 66. So if my sales people are giving a
quote say for 3000 bricks this would not be possiable because they only
come in lots of 66, the figue they would have to enter would be 3036. I
was wondering if there is a way to get the cell to show an error if the
figue entered dose not work with multiables of 66. Thanks