Thread: Trying to use IF statement with hyphen
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AmytDev AmytDev is offline
external usenet poster
  
Posts: 5
Default Trying to use IF statement with hyphen
I"m struggling with trying to get this function to work.
=IF((LEFT(Data!$I$2,3))="-","",((Data!$I$2)))

If the third character is a hyphen, I want the data in the cell to be blank
otherwise, I want the value of I2 in that cell.

Any ideas?
Amy
Reply With QuoteReply With Quote