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

  • Thread starter Thread starter christopherphartley
  • Start date Start date
C

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?
 
If your number is in A2, then put this formula in B2...

=10*TRUNC(A2/10)

and put this number in C2...

=A2-B2
 
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
 
Back
Top