Display Part of the cell value

[ramana]

Hi Everybody,

From a calculation part(formula in a cell) I'm getting a value
wuth three decimal places.(ex: 27.874) Now I wanted this result should
be displayed in two cells as value befor e the decimal point and in
second cell after the decimal point.

Ex: In Cell C1 I have 27.874
then D1 = 27
E1 = 0.874

Is it possible, If so pl tell me.

Thanks and Regards

Ramana

 

[Guest]

in cell D1 use

=TRUNC(C1)

in E1 use

=C1-D1

 

[Bob Phillips]

D1: =INT(C1)
E1: =MOD(C1,1) or =C1-D1

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[ramana]

Hi,

Thank you verymuch for your replies.

Thanks and Regards

Ramana

 

[Ron Rosenfeld]

D1: =INT(C1)
E1: =MOD(C1,1) or =C1-D1

Only for positive numbers, though.


--ron

 

[Ron Rosenfeld]

Hi Everybody,

From a calculation part(formula in a cell) I'm getting a value
wuth three decimal places.(ex: 27.874) Now I wanted this result should
be displayed in two cells as value befor e the decimal point and in
second cell after the decimal point.

Ex: In Cell C1 I have 27.874
then D1 = 27
E1 = 0.874

Is it possible, If so pl tell me.

Thanks and Regards

Ramana

How do you want to display the fractional portion if the number is negative?

With the negative sign in front of both, then Duke's formulas work. If you
want the fractional part to be positive, then his second formula should be:

=ABS(C1-D1)


--ron

 

[ramana]

Thanks Ron for the formula

Rgds

Ramana