how do I protect the formula, when I put in the number 20 it erases the
formula.
--
glen


"Mike H" wrote:

Try

=CEILING(A1,3)

Mike

"Silverline" wrote:

what formula is used when you enter a number into cell and it is round up to
a multiple of 3. So if 20 is entered in a cell that it is changes it to 21.
--
glen