Thank-you Lori, that is exactly as I saw it.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Lori" wrote in message
oups.com...
I see your point Sandy. Bob and I assumed that since two sigificant
figures of precision were given in the examples and no decimal places
in the answer that this meant the number of digits entered defined the
precision (543210 - 54321 & 10). I think this made for a more
interesting problem but taken as written your answer seems perfectly
adequate.


Sandy Mann wrote:

Hi Bob,

I'm obviously not understanding what is required because I took the OP's

from A2 cell and shows me 2 digit number in one cell and 10
multiplicity in another

to mean that they wanted a two digit number in one cell and a multiple
of 10
in the other so that when they were multiplied together gave the
original
number.

For 100 I get 10 & 10 is this not correct? With you formula I get 1 &
100
which does not meet the OP's two digit requirement.


--
Puzzled,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Bob Phillips" wrote in message
...
100 isn't right for one.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Sandy Mann" wrote in message
...
Maybe I'm completely off the wall with this and I am not
understanding
what
is required but won't:

=A11/10^(LEN(INT(A11))-2-(A11<1))

and A11/B11

give you what you are looking for?

0,12 gives 12 & 0,01
53000 gives 53 & 1000
1,1 gives 11 & 0,1
-100 gives -10 & 10
12.1 gives 12.1 & 1
(because you want two figures)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Perus" wrote in message
oups.com...
Hello.
I don't know "math english" well so forgive me mistakes.
I've got a question.How should the formula look which will: take
number
from A2 cell and shows me 2 digit number in one cell and 10
multiplicity in another
E.g.
0,12 will be shown as 12 in one cell and 0,01 in another
53000 will be shown as 53 and 1000.
10 multiplicities range is from 0,01 to 1000000000 (10^ -2 to 10^9)
Hope you will help me :D
Kacper.