Thread: need to detect syntax in value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
J.Parker J.Parker is offline
external usenet poster
  
Posts: 1
Default need to detect syntax in value
I'm trying to display Cxld in the cell for my sum when cxld is detected in
the cell not a numerical value. here is what i though would be the correct
formula =IF(B7=cxld,"CXLD",(C7-B7))
Reply With QuoteReply With Quote