Decimal Places
 

If I have a number in a cell (e.g., 3.456), how can I return just the decimal
part of it (0.456) to another cell? Conversely, if I have Cell 1 = 50 and
Cell 2 = 55, how can I join them in a new cell to make the number 50.55?

Decimal Places
 

=MOD(A1,1)

=A1+A2/100


--
Regards,

Peo Sjoblom



"college student ATL" <college student wrote
in message ...
If I have a number in a cell (e.g., 3.456), how can I return just the
decimal
part of it (0.456) to another cell? Conversely, if I have Cell 1 = 50 and
Cell 2 = 55, how can I join them in a new cell to make the number 50.55?

Decimal Places
 

Your second formula fail, if

A1= 50
A2= 578

=A1+A2/100
Your formula returns 55.78, should be 50.578

Teethless mama formula return 50.578
=A1+A2/(10^LEN(A2))


"Peo Sjoblom" wrote:

=MOD(A1,1)

=A1+A2/100


--
Regards,

Peo Sjoblom



"college student ATL" <college student wrote
in message ...
If I have a number in a cell (e.g., 3.456), how can I return just the
decimal
part of it (0.456) to another cell? Conversely, if I have Cell 1 = 50 and
Cell 2 = 55, how can I join them in a new cell to make the number 50.55?

Decimal Places
 

Slightly more efficient:

=--(A1&"."&A2)

In article ,
Teethless mama wrote:

Your second formula fail, if

A1= 50
A2= 578

=A1+A2/100
Your formula returns 55.78, should be 50.578

Teethless mama formula return 50.578
=A1+A2/(10^LEN(A2))


"Peo Sjoblom" wrote:

=MOD(A1,1)

=A1+A2/100


--
Regards,

Peo Sjoblom



"college student ATL" <college student wrote
in message ...
If I have a number in a cell (e.g., 3.456), how can I return just the
decimal
part of it (0.456) to another cell? Conversely, if I have Cell 1 = 50 and
Cell 2 = 55, how can I join them in a new cell to make the number 50.55?

Decimal Places
 

Teethless mama formula return 50.578
=A1+A2/(10^LEN(A2))

Two parentheses more than needed...

=A1+A2/10^LEN(A2)

Rick