insert logical formula in excel worksheet

M

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

Pete_UK

Try this:

=H58=INT(H58)

will return TRUE or FALSE accordingly.

Hope this helps.

Pete
 
Top