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
|