Thread: INT Function
View Single Post
  #4   Report Post  
Harlan Grove
 
Posts: n/a
Default

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!.