need to detect syntax in value

  • Thread starter Thread starter J.Parker
  • Start date Start date
J

J.Parker

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))
 
Back
Top