Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
insert logical formula in excel worksheet
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with Logical Formula | Excel Worksheet Functions | |||
EXCEL LOGICAL FORMULA, PLEASE HELP! | Excel Worksheet Functions | |||
Unable to Insert Worksheet/Move and copy worksheet Excel 2003 | Excel Worksheet Functions | |||
Excel Logical Formula | Excel Discussion (Misc queries) | |||
Excel should speak results of logical formula | Excel Worksheet Functions |