View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jheath.bc jheath.bc is offline
external usenet poster
 
Posts: 1
Default 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)