Re: Rounding up to the nearest 6" increment

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: "Bob Phillips" <phillips@xxxxxxxxxxxxx>
Date: Wed, 20 Jul 2005 19:20:55 +0100

=ROUNDUP(A2/6,0)*6

or

=CEILING(A2,6)

--
HTH

Bob Phillips

"GreenMonster" <jwinder@xxxxxxxxxxxxxxxxxxx> wrote in message
news:I8wDe.152770$g5.24642@xxxxxxxxxxxxxxxxxxxxxxx
> I need a function that rounds a number up to the nearest 6" increment
>
> In other words, if the number to be rounded is 19" the value returned
would
> be 24". If the number is 20" the value returned would also be 24".
>
> To complicate matters, if the number to be rounded up is less than or
equal
> to 2" then the the returned value needs to be then 2nd nearest 6"
increment.
>
> In other words, if the number to be rounded is 17" or 16" then the
returned
> value needs to be 24". 15" would round to 18", as would 14, 13, and 12.
10
> and 11 would also round to 18".
>
> Make sense? Hope so.
>
> Thanks
>
>

.

References:
- Rounding up to the nearest 6" increment
  - From: GreenMonster

Prev by Date: RE: Rounding up to the nearest 6" increment
Next by Date: Re: first column in row
Previous by thread: Re: Rounding up to the nearest 6" increment
Next by thread: Click Event taking time
Index(es):
- Date
- Thread

Relevant Pages

Re: Very confused by Ada tasking, can not explain the execution outcome.
... is never executed, but the task terminates. ... The only procedure increment ... 'rounds' is procedure 'use_res', but the procedure was never called ... the task execution, ...
(comp.lang.ada)
Re: Very confused by Ada tasking, can not explain the execution outcome.
... is never executed, but the task terminates. ... The only procedure increment ... 'rounds' is procedure 'use_res', but the procedure was never called ... during the execution. ...
(comp.lang.ada)
Re: Round up entire worksheet
... That means to roundup to the next increment of 1. ... Rounds up to the next increment of 10. ... for the rounded amount. ... I don't have to do this cell by cell do I? ...
(microsoft.public.excel.worksheet.functions)
Rounding up to the nearest 6" increment
... I need a function that rounds a number up to the nearest 6" increment ... Prev by Date: ...
(microsoft.public.excel.programming)
Re: Roundup or Ceiling Function to round to a specific number
... "David Biddulph" wrote: ... I would also like a formula to rounddown to the nearest 49p or 99p. ... "Bob Phillips" wrote: ... It rounds down a number like 1990 to 1989 ...
(microsoft.public.excel.misc)