Roundup to the nearest number that is divisible by 3
 

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

Raju,

This is a 1 year old thread.

Mangesh




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


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=227459