Display Part of the cell value

R

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
 
B

Bob Phillips

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

--

HTH

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

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
Click to expand...

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
 
Top