Thread: INT Function
View Single Post
  #3   Report Post  
Fred Smith
 
Posts: n/a
Default

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)

--
Regards,
Fred


"Dan (WA)" <Dan wrote in message
...
I need the remainder results of a multiplication formula. The Function INT
should provide this results -- Excel Function Help for INT provide the
formula =A2-INT . I have tried this sever times but the results is alway the
same #Name... Is excel broken or what am i missing?