Thread: If function with text
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel.worksheetfunctions
Don Guillett Don Guillett is offline
external usenet poster
  
Posts: 10,124
Default If function with text
try
=IF(ISTEXT(a1),"","Nottext")

--
Don Guillett
SalesAid Software

"Richard" wrote in message
. ..
I posted a question about if function earlier, but here is the a new twist.
I want to use a function probably the if function to check if say from cell
A2 to E1 to see if the value is less than .5 or no data or equal to o, if
true than give cell F1 a value of 1, and if cell A1 has not text in it,
then, give cell F1 a blank or nothing. How do I write this function?




Reply With QuoteReply With Quote