Don't see how

=INT(A1)+A1

would work.

The only problem with MOD(A1,1)=0 is that, for calculated values, a
small rounding error gives a false negative.


In article ,
"Bob Phillips" wrote:

You could also use

=INT(A1)+A1

or

=MOD(A1,1)=0