Hi Marcy,

This is Raju. Here is the solution and procedure.

if you have value at cell A1 that is 5081
write this formulea at B1 which is =ROUND(A1/3,0)*3 which give you 5082 in
the B1 cell.

Hope i am clear to the point what Vaughan tries to explain

Thanks
Raju
"Vaughan" wrote:

Oh by the way, the self reference wis unnecessary, just put your formula in another column and hide the original

"Vaughan" wrote:

How about if you divide your number by three first, then round it up to the next whole number, then multiply the result by three. I think that would work?

"Marcy" wrote:

Can someone please tell me how I can roundup a number in a cell to the next number that is evenly divisble by 3?

For ex., cell A1 = 5081 which is NOT evenly divisble by 3, so I would want cell A1 to be 5082 (or 1694*3)

The part that is puzzling me is how I can refer to the number that already exists in the cell without causing an error or circular reference. I am sure I am overlooking the obvious at this point but frustration has taken hold and I am running out of time playing with this!

Your help is most appreciated!
BTW, the new site looks great!
--
Marcy