View Single Post
  #14   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default Roundup or Ceiling Function to round to a specific number

That thought occurred to me Joe, but I decided against messing with the OPs
data/original req <G

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

wrote in message
oups.com...
Errata ....

I wrote:
Bob Phillips wrote:
I think it is the D8/0.67, I think that has a small increment in it

which
makes a number that looks like 1625 actually be something like

16.000001 ort
so, which will go up.


I am not following this discussion closely, but I wonder if D8*2/3
yields the desired results. Just a WAG, really.


First, that should be D8*3/2. Second, ignore my comment. It does not
seem relevant to the crux of the thread.