Thread: Conditional formula if content is text
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
a m spock a m spock is offline
external usenet poster
  
Posts: 50
Default Conditional formula if content is text
How do i write an IF statement which does Task A if contents of a certain
cell are a TEXT and Task B if it is a numerical value. e.g. If(A1=any
text,1,0) or If(a1=specific text,1,0)
Reply With QuoteReply With Quote