Rounding to whole numbers and taking the left overs to a new cell

[christopherphartley]

I need to create a formula that will take a number like 598.1774 and
put it into two different cells. I would like one cell to contain a
whole number (590 or I suppose 598, but i'd prefer 590) and in the
other cell put the left overs (8.1774 or .1774).

Does anyone have a quick solution to this one?

 

[Rick Rothstein]

If your number is in A2, then put this formula in B2...

=10*TRUNC(A2/10)

and put this number in C2...

=A2-B2

 

[muddan madhu]

another one...

value is A1, then in B1 =FLOOR(A1,10) , C1= A1-B1

 

[Shane Devenshire]

Hi,

You could also try

=ROUNDDOWN(A1,-1)

=A1-B1

or if you want the decimal portion separated out

=MOD(A1,1)

=A1-B1

If these help, please click the Yes button

Cheers,
Shane Devenshire