Hello.
I’m trying to figure out how to separate a whole number from the remainder.
For example, after and equation I get (3.14). I’d like the 3 in one column and the .14 to be saved in another so I can carry it to the next calculation.
Is this possible?
Thank you,
-Chris
Please note that numerical contents and results (numbers) may also be negative.
You will have to decide explicitly if you want -3.14 to be split into (-3|-0.14) or (-4|+0.86).
The suggestion by @librebel will return the second pair.
Look at the functions MOD and ROUND or ROUNDDOWN
Also QUOTIENT:
=QUOTIENT(20;3)
gives 6
=MOD(20;3)
gives 2
In fact MOD(Dividend;Divisor) also accepts negative numbers and non-integers.
It is defined generally as
MOD(Dividend;Divisor) = Divisor - INT(Dividend/Divisor)*Divisor
where the INT(Dividend/Divisor) differs from QUOTIENT(Dividend;Divisor) if the two arguments have different signs.
Hello @codewolf,
Suppose that your value 3.14 is located in cell A1,
To get the integral part ( =3 ) just put the following formula into cell B1:
= INT( A1 )
To get the decimal part ( =0.14 ) put the following formula into cell C1:
=A1 - INT( A1 )
HTH, lib
IMO, the MOD is the proper solution, because it is not only solving the task, but also self-documenting and telling: =MOD(A1;SIGN(A1))
sorry, but this answer is wrong.
As above comment says correctly: MOD() is the proper function here!