Fred Smith wrote...
You need to supply a parameter to the INT function. To get the portion to the
right of the decimal, use:
=a2-int(a2)
You can also get the same thing in one step with the Mod function:
=mod(a2,1)
....
Use the INT formula. MOD is broken when quotients are large, e.g.,
=2^30/3-INT(2^30/3)
correctly returns 1/3 (approximately, accurate to only 7 decimal
digits), while
=MOD(2^30/3,1)
returns #NUM!.
|