| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Logical test IF a decimal was typed in a cell
I'm wondering if there is a way to create a logical test to find out if a
decimal point was typed in a cell. "16" would be false. "16." would be true. =if(a1 contains a decimal,a1,else use other formula) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| logical test for an #N/A condition in a cell | Excel Discussion (Misc queries) | |||
| Logical test if cell uses formatting.. | Excel Worksheet Functions | |||
| IF functionality, Logical Test = Nonbalnk Cell | Excel Worksheet Functions | |||
| Logical Test comparison using cell color | Excel Discussion (Misc queries) | |||
| logical test for each and every cell in range | Excel Discussion (Misc queries) | |||
Threaded Mode
