insert logical formula in excel worksheet

[mimi]

how to insert formula :

cell H58 = 2.667
result => statement is wrong if there is decimal point;

cell H58 = 2
result => statement is true if there is full figure number

thanks for help.

 

[Pete_UK]

Try this:

=H58=INT(H58)

will return TRUE or FALSE accordingly.

Hope this helps.

Pete