View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default insert logical formula in excel worksheet

Try this:

=H58=INT(H58)

will return TRUE or FALSE accordingly.

Hope this helps.

Pete

On Apr 10, 1:49*am, mimi wrote:
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.