Ah, but David, that is good enough, especially since I want to round up to
the next full number afterwards. Besides, how is dividing by 25.4 more
accurate than multiplying with 0.039?
That convert function, on the other hand, that looks interesting. It's not
working for me though. Could that be because I have a formula in B1 (see
above)?

Niniel wrote on Thu, 4 Oct 2007 10:24:02 -0700:

N Ah, but David, that is good enough, especially since I want
N to round up to the next full number afterwards. Besides, how
N is dividing by 25.4 more accurate than multiplying with
N 0.039? That convert function, on the other hand, that looks
N interesting. It's not working for me though. Could that be
N because I have a formula in B1 (see above)?

Multiplying by 0.039 may well be sufficiently accurate for uour
purposes but 1 inch is *exactly* 25.4 mm and 1/0.039 is
25.64102564.........

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.verizon.not

Oh, ok.
Thanks for the education. :)

Looks like I don't have the right component installed:

"If this function is not available, and returns the #NAME? error, install
and load the Analysis ToolPak add-in."

If you have the CD/DVD you can just do toolsadd-ins and select Analysis
ToolPak and follow the directions


--


Regards,


Peo Sjoblom



"Niniel" wrote in message
...
Looks like I don't have the right component installed:

"If this function is not available, and returns the #NAME? error, install
and load the Analysis ToolPak add-in."

Thank you.
Turns out, the add-in had been there all along, it just wasn't loaded.

See what you get if the number of mm is 25400. Your 0.039 multiplication
would round up to 991. Do you consider that close enough to the correct
answer of 1000 ?

I think you've subsequently answered your own question about CONVERT, by
switching on the Analysis ToolPak.
--
David Biddulph

"Niniel" wrote in message
...
Ah, but David, that is good enough, especially since I want to round up to
the next full number afterwards. Besides, how is dividing by 25.4 more
accurate than multiplying with 0.039?
That convert function, on the other hand, that looks interesting. It's not
working for me though. Could that be because I have a formula in B1 (see
above)?

My numbers won't exceed 3000, but I see what you mean.

Interestingly enough, CONVERT doesn't come up with exactly the same numbers
as the division (identical for 3 decimals), but it does pass the 25400 test.